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
8803 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 policy management?

936

How do you debug a procedure in sql server?

893

Explain system views?

1024

How to sort the query output with order by clauses in ms sql server?

984

What is faster join or union?

1112

What is the difference between sdf and mdf?

1234

What is the difference between stored procedure and functions?

1064

How will you optimize a stored procedure optimization?

956

how many clustered indexes can be created on a table? : Sql server database administration

1068

what is difference between NULL and ISNULL in SQL Server 2008?

967

Can a trigger be created on a view?

896

Explain an incremental backup?

939

What are subqueries in sql server? Explain its properties.

968

Explain index in sql server?

966

Explain what are partitioned views and distributed partitioned views?

893