CREATE TABLE test (A INT IDENTITY ,B INT)
INSERT INTO test (B) VALUES ('sathya')
SELECT * FROM test
INSERT INTO test (B) VALUES (1)
SELECT * FROM test
Identity column is getting incremented,though the first insert doesnt happen.
INSERT INTO test (B) VALUES ('sathya')
SELECT * FROM test
INSERT INTO test (B) VALUES (1)
SELECT * FROM test
Identity column is getting incremented,though the first insert doesnt happen.
No comments:
Post a Comment