SQL Server/T-SQL Tutorial/Query/rowversion

Using a Table with a rowversion Column

   <source lang="sql">

3> CREATE TABLE MyTable( 4> DataValue int NOT NULL, 5> RowVer rowversion NOT NULL 6> ) 7> GO 1> INSERT MyTable (DataValue) VALUES (1) 2> INSERT MyTable (DataValue) VALUES (2) 3> INSERT MyTable (DataValue) VALUES (3) 4> INSERT MyTable (DataValue) VALUES (4) 5> GO (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) 1> UPDATE MyTable 2> SET 3> DataValue = 10 4> WHERE 5> DataValue = 3 6> GO (1 rows affected) 1> SELECT 2> * 3> FROM 4> MyTable 5> GO DataValue RowVer

---

------------------------------------------------------------------------------------------------------------

---

---

---

---

         1 0x0000000000000FB0

         2 0x0000000000000FB1

        10 0x0000000000000FB4

         4 0x0000000000000FB3

(4 rows affected) 1> 2> drop table MyTable 3> GO</source>