SET IDENTITY_INSERT dbo.test1 OFF Then 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 / s pattnaik

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

Answer Posted / s pattnaik

SET IDENTITY_INSERT dbo.test1 OFF
Then
insert into test1(Id ,id_name) values (2 ,'insertedat2')

Is This Answer Correct ?

6 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know what are the properties of the relational tables?

1029

How to get the definition of a stored procedure back?

977

What are truncate options available in sql server? : sql server database administration

1024

What is create command?

968

How to install sql server 2005 express edition?

1120

What does REVERT do in SQL Server 2005?

957

How to delete existing triggers using "drop trigger"?

1051

Explain syntax for viewing trigger?

922

What is an example of a foreign key?

973

What is the full form of dql?

981

How to use order by with union operators in ms sql server?

1021

What do you understand by a view?

996

How do I view a procedure in sql server?

987

How do we Backup SQL Azure Data?

108

Why do we backup Active Directory ?

1040