set identity_insert <table_name> on insert into text1(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 / challa yerriswamy

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

Answer Posted / challa yerriswamy

set identity_insert <table_name> on
insert into text1(id,id_name) values(2,'insertedat2')

Is This Answer Correct ?

13 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain data warehousing in sql server?

1043

How to provide values to stored procedure parameters in ms sql server?

1035

Which tcp/ip port does sql server run on? How can it be changed?

1034

Can one drop a column from a table?

1018

Can I run multiple instances of sql server 2000 at the same time on one computer?

1072

Can we use where clause in union?

1063

What is purpose of normalization?

944

What are basics of policy management?

1098

Difference between aggregate functions of sql?

1101

What happens if null values are involved in boolean operations?

985

Relational calculus is what type of language?

1032

Why use sub query in sql server and list out types of sub queries?

998

What is GUID in sql server?

1159

What is the difference between a unique key and primary key?

945

What is BCP? When does it used in sql server 2012?

1056