SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE T (ID int, ts timestamp NOT NULL);
INSERT INTO T(ID)
VALUES (1),(2),(3),(4),(5),(6),(7),(9);
8 rows affected

SELECT *
FROM T;


ID
ts


1
0x00000000000007D1

2
0x00000000000007D2

3
0x00000000000007D3

4
0x00000000000007D4

5
0x00000000000007D5

6
0x00000000000007D6

7
0x00000000000007D7

9
0x00000000000007D8


UPDATE T
SET ID = 8
WHERE ID = 9;
1 rows affected

SELECT *
FROM T;


ID
ts


1
0x00000000000007D1

2
0x00000000000007D2

3
0x00000000000007D3

4
0x00000000000007D4

5
0x00000000000007D5

6
0x00000000000007D6

7
0x00000000000007D7

8
0x00000000000007D9

ID	ts
1	0x00000000000007D1
2	0x00000000000007D2
3	0x00000000000007D3
4	0x00000000000007D4
5	0x00000000000007D5
6	0x00000000000007D6
7	0x00000000000007D7
9	0x00000000000007D8