Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE #a(identity_column INT IDENTITY(1,1), x CHAR(1));
- INSERT #a(x) VALUES('a');
- SELECT SCOPE_IDENTITY();
- ----
- 1
- INSERT #a(x)
- OUTPUT inserted.identity_column
- VALUES('b'),('c');
- ----
- 2
- 3
- CREATE TABLE ReverseIdent (
- id int IDENTITY(9000,-1) NOT NULL PRIMARY KEY CLUSTERED,
- data char(4)
- )
- INSERT INTO ReverseIdent (data)
- VALUES ('a'), ('b'), ('c')
- SELECT * FROM ReverseIdent
- SELECT IDENT_CURRENT('ReverseIdent') --8998
- SELECT MAX(id) FROM ReverseIdent --9000
- SET IDENTITY_INSERT ReverseIdent ON
- INSERT INTO ReverseIdent (id, data)
- VALUES (9005, 'd')
- SET IDENTITY_INSERT ReverseIdent OFF
- SELECT IDENT_CURRENT('ReverseIdent') --8998
- SELECT MAX(id) FROM ReverseIdent --9005
Add Comment
Please, Sign In to add comment