CREATE TABLE testIdentity (id int IDENTITY (1,1), name nvarchar(100));

INSERT INTO testIdentity(name) VALUES ('name1');                        è Row will be (1, name1)

INSERT INTO testIdentity(name) VALUES ('name2');                        è Row will be (2, name2)

SET IDENTITY_INSERT testIdentity ON;

INSERT INTO testIdentity (id, name) VALUES (10, 'name10');       è Row will be (10, name10)

INSERT INTO testIdentity (id, name) VALUES (20, 'name20');       è Row will be (20, name20)

SET IDENTITY_INSERT testIdentity OFF;

INSERT INTO testIdentity(name) VALUES ('name??');                       è Row will be (3, name??)