TSQL Rowversion

Rowversion.sql

/*
DROP TABLE IF EXISTS [dbo].[MyTab]
GO
CREATE TABLE [dbo].[MyTab](
	[ID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
	[Value] [nvarchar](50) NOT NULL,
	[Version] [rowversion] NOT NULL,
)
*/

/*
INSERT INTO MyTab (Value)
VALUES
	('Val1'),
	('Val2'),
	('Val3'),
	('Val4'),
	('Val5')
*/

--SELECT	@@DBTS --Current rowversion for the database

SELECT * FROM MyTab

DECLARE @ver rowversion
SELECT	@ver = Version FROM MyTab WHERE ID = 2

UPDATE	MyTab
SET		Value = 'Value 2'
WHERE	ID = 2
		AND Version = @ver

SELECT * FROM MyTab