-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE TABLE ts(
    id INTEGER NOT NULL,
    ver ROWVERSION,
    PRIMARY KEY(id)
)
GO
INSERT INTO ts(id) VALUES(1)
GO
INSERT INTO ts(id) VALUES(2)
GO
INSERT INTO ts(id) VALUES(3)
GO
SELECT * FROM ts
GO
UPDATE ts SET id=id WHERE id=3
GO
SELECT * FROM ts
GO
DROP TABLE ts
GO
