set identity_insert on insert into test1(Id ,id

here id col have primary key and identity
id name
1 a
2 b
3 c
4 d

delete 2nd row then o/p will be

id name
1 a
3 c
4 d

next inssert 2nd row and i want o/p will be
id name
1 a
2 e
3 c
4 d

Question Posted / pradeep aryan

7 Answers
8875 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / pradeep aryan

set identity_insert on
insert into test1(Id ,id_name) values (2 ,'e')
set identity_insert off

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is row_number function?

960

Explain raiserror in sql server?

976

What is a rownum?

920

How to get the number of affected rows?

974

Can a table be moved to different filegroup?

938

How to find which stored procedure is currently running in sql server?

939

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1018

How to delete database objects with "drop" statements in ms sql server?

1054

What happens when transaction log is full?

885

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

995

How do I debug a stored procedure in sql server?

1050

What do you understand by coalesce in sql server?

1021

Which is the latest version of sql server and when it is released?

1061

Is sql server a database?

938

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1001