· 9 years ago · Jan 31, 2017, 10:06 PM
1/*
2DROP TABLE IF EXISTS [dbo].[MyTab]
3GO
4CREATE TABLE [dbo].[MyTab](
5 [ID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
6 [Value] [nvarchar](50) NOT NULL,
7 [Version] [rowversion] NOT NULL,
8)
9*/
10
11/*
12INSERT INTO MyTab (Value)
13VALUES
14 ('Val1'),
15 ('Val2'),
16 ('Val3'),
17 ('Val4'),
18 ('Val5')
19*/
20
21--SELECT @@DBTS --Current rowversion for the database
22
23SELECT * FROM MyTab
24
25DECLARE @ver rowversion
26SELECT @ver = Version FROM MyTab WHERE ID = 2
27
28UPDATE MyTab
29SET Value = 'Value 2'
30WHERE ID = 2
31 AND Version = @ver
32
33SELECT * FROM MyTab