Cov txheej txheem:

Yuav ua li cas kom tau txais tus yuam sij surrogate?
Yuav ua li cas kom tau txais tus yuam sij surrogate?

Video: Yuav ua li cas kom tau txais tus yuam sij surrogate?

Video: Yuav ua li cas kom tau txais tus yuam sij surrogate?
Video: Qiv Koj Lub Plab Tau 9 Lub Hli~05/23/2023~ 2024, Kaum ib hlis
Anonim

A tus tseem ceeb hauv SQL Server yog tsim los ntawm kev muab cov khoom ntiag tug rau ib kab uas muaj tus lej cov ntaub ntawv. A tus tseem ceeb yog tus nqi tsim tawm ua ntej cov ntaub ntawv muab tso rau hauv lub rooj. Muaj ob peb lub laj thawj los hloov lub ntuj tus yuam sij nrog a tus tseem ceeb.

Tib neeg kuj nug, tus piv txwv tseem ceeb ntawm tus neeg sawv cev yog dab tsi?

A tus tseem ceeb yog tus cim tshwj xeeb uas siv rau hauv cov ntaub ntawv rau cov qauv qauv lossis cov khoom siv. Nws yog ib qho tshwj xeeb tus yuam sij Nws tsuas yog qhov tseem ceeb yog los ua tus cim tseem ceeb ntawm ib qho khoom lossis qhov chaw thiab tsis tau muab los ntawm lwm cov ntaub ntawv hauv cov ntaub ntawv thiab tej zaum yuav tsis siv los ua qhov tseem ceeb. tus yuam sij.

Qhov thib ob, qhov txawv ntawm tus yuam sij tseem ceeb thiab tus yuam sij surrogate yog dab tsi? A thawj tus yuam sij yog ib qho kev txwv tshwj xeeb ntawm ib kab los yog kab ke. A tus tseem ceeb yog txhua kab los yog kab ke uas tuaj yeem tshaj tawm raws li tus thawj tus yuam sij es tsis yog "tiag" lossis ntuj tus yuam sij . Qee lub sij hawm tuaj yeem muaj ntau yam ntuj tso yuam sij uas tuaj yeem tshaj tawm tias yog thawj tus yuam sij , thiab tag nrho cov no yog hu ua tus neeg sib tw yuam sij.

Tsis tas li ntawd, koj yuav ua li cas thiaj tsim tau tus yuam sij surrogate?

Tsim cov yuam sij surrogate

  1. Nyem qhov Properties tab.
  2. Ntaus ib lub npe rau kab ntawv tseem ceeb nyob rau hauv lub Generated Output Column Name khoom.
  3. Ntaus lossis tshawb rau lub npe ntawm qhov chaw.
  4. Xaiv hom qhov chaw.
  5. Yog hais tias lub hauv paus hom yog ib tug database sequence, txhais cov Database Type properties.
  6. Yog tias qhov chaw tseem ceeb yog cov ntaub ntawv tiaj tus, qhia seb cov yuam sij raug tsim li cas:

Thaum twg koj yuav siv tus yuam sij surrogate?

Sab saum toj 3 Yog vim li cas ib txwm siv Surrogate Keys nyob rau hauv cov ntaub ntawv Warehousing

  1. Kev hloov qeeb qeeb. Nws feem ntau yog qhov yuav tsum tau taug qab cov txiaj ntsig keeb kwm ntawm cov ntaub ntawv qhov ntev. Piv txwv li; tus neeg siv khoom loj tuaj yeem muaj qhov chaw zip code.
  2. Hloov qhov Systems. Siv cov yuam sij ntuj nruj nreem khi cov ntaub ntawv warehouse qhov kev ncaj ncees rau kev ruaj ntseg ntawm qhov system.
  3. Kev ua tau zoo.

Pom zoo: