dotnetomaniak.pl

Strona głównaBazy danych i XML

We have many solutions for versioning data through time. One of the cleanest, most transparent and pretty effortless in my opinion are Temporal Tables which are available in MS SQL 2016+. What’s really great about that approach is that unless you need to retrieve state from the certain point in time or browse through changes in a specified time range, you can query against a versioned table in an exactly same way that you would do with any other one.

Źródło: hryniewski.net
Dziel się z innymi:
Versioning data with MS SQL Temporal Tables – Hryniewski.NET
Wczytywanie artykułów...
Szkolenia SecurITum

maj

26.

wrzesień

21.
Dev#
Gdańsk, Stary Maneż
Dodaj nowe Zobacz wszystkie

Najaktywniejsi

1

Paweł Łukasik (32 867,57)

2

macko (32 816,53)

3

pzielinski (27 178,29)

4

gordon_shumway (21 178,88)

5

paduda (20 336,33)

6

psz750 (13 018,14)

7

rroszczyk (10 391,47)

8

Damian (9 535,25)

9

danielplawgo (7 371,05)

10

arek (6 807,95)

11

burczu (6 214,22)

12

PaSkol (5 393,84)

13

lukaszgasior (4 097,38)

14

jj09 (3 818,06)

15

dpawlukiewicz (3 632,16)

16

spetz (3 418,34)

17

AdrianBystrek (3 345,84)

18

jedmac (3 318,39)

19

http://jakub-flor... (3 224,66)

20

CaMeL (2 954,87)