Qhov System Versioning hauv SQL Server yog dab tsi?
Qhov System Versioning hauv SQL Server yog dab tsi?

Video: Qhov System Versioning hauv SQL Server yog dab tsi?

Video: Qhov System Versioning hauv SQL Server yog dab tsi?
Video: QHIA QHOV TSEEB - KUB VAJ LOOG TSUA NEW MUSIC VIDEO 2022 2024, Kaum ib hlis
Anonim

Temporal, los yog qhov system - versioned , cov ntxhuav tau qhia raws li lub hauv paus ntsiab lus hauv SQL Server 2016. Qhov no muab peb hom rooj uas tuaj yeem muab cov ntaub ntawv hais txog cov ntaub ntawv uas tau muab khaws cia rau txhua lub sijhawm tsis yog cov ntaub ntawv tam sim no.

Ua raws li qhov no saib, System versioned rooj hauv SQL Server yog dab tsi?

Temporal rooj , kuj hu ua qhov system - versioned rooj , muab kev ua haujlwm tshiab rau peb los taug qab cov ntaub ntawv hloov pauv. Nws tso cai SQL Server tswj thiab tswj cov keeb kwm ntawm cov ntaub ntawv nyob rau hauv lub rooj txiav txim. Qhov no feature muab tag nrho keeb kwm ntawm txhua qhov kev hloov pauv ua rau cov ntaub ntawv. Nws txhais lub validity ntawm cov ntaub ntawv.

Tsis tas li ntawd, kuv yuav ua li cas poob lub rooj zaum hauv SQL Server? Koj ua tsis tau xwb poob ib lub rooj ntawm lub cev . Koj yuav tsum xub lov tes taw versioning, uas yuav ua rau cov keeb kwm rooj los ua ib tug dog dig rooj . Ces koj ua tau poob ob lub lub rooj zaum thiab nws cov keeb kwm sib thooj rooj.

Kuj nug, dab tsi yog generated ib txwm kem hauv SQL Server?

Cov TSEEM CEEB AS ROW START kem sawv cev rau lub sijhawm thaum cov ntaub ntawv kab dhau los ua tam sim no, pib ntawm INSERT / HLOOV ntawm cov ntaub ntawv nyob rau hauv qhov system-versioned temporal table, lub kaw lus yuav teem sijhawm UTC tam sim no raws li lub moos system qhov twg SQL Server ua piv txwv.

Dab tsi yog qhov hloov pauv hauv SQL Server?

Hloov kev taug qab yog ib qho kev daws teeb meem uas muab kev ua tau zoo hloov kev taug qab mechanism rau kev siv. Feem ntau, txhawm rau pab kom cov ntawv thov nug rau kev hloov mus rau cov ntaub ntawv nyob rau hauv ib tug database thiab nkag mus rau cov ntaub ntawv uas muaj feem xyuam rau lub kev hloov , application developers yuav tsum ua raws li kev cai hloov kev taug qab mechanisms.

Pom zoo: