write a query to insert into a identity column

Question

I have used identity key in a column of a table like

create table test(testid int identity(1,1),testname varchar(10))

and then I have inserted 2 rows like

Insert into test(testname) values('c')
Insert into test(testname) values('c#')

Now,My table contains like below:

1     c    
2     c#

But,I want insert another row into this table test like 5 c++

So,My table will contain like

1       c   
2       c#  
5      c++

So,please send me the output as soon as possible.Help me please.

Do you really need the testid column to be identity if you have the need to insert arbitrary values into it? — Andriy M
– Andriy M, Commented Jul 8, 2012 at 14:35

Oded · Accepted Answer · 2012-07-08 11:17:46Z

4

SET IDENTITY_INSERT test ON;

Insert into test(testid, testname)values(5, 'c++');

SET IDENTITY_INSERT test OFF;

answered Jul 8, 2012 at 11:17

Oded

501k102 gold badges899 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kapil Khandelwal · Accepted Answer · 2012-07-08 11:17:31Z

1

SET IDENTITY_INSERT test ON

INSERT test (testid , testname)
VALUES (5, 'c++')

SET IDENTITY_INSERT test OFF

answered Jul 8, 2012 at 11:17

Kapil Khandelwal

16.2k3 gold badges49 silver badges55 bronze badges