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
9307 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

What is reference section?

1060

What is merge replication?

1153

What is a view and what are its advantages?

1171

Explain about integration services of Microsoft SQL server?

1093

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1316

What are the different types of join?

1243

How can you start sql server in different modes?

1021

What is the difference between implicit and explicit transaction?

1054

Define tool Manage Statistics in SQL Server 2000 query ?

1168

What is a functions and types in sql server?

1151

What is the distinction amongst delete and truncate?

1120

Different types of keys in SQL?

1149

How to send email from database?

1073

Name few of the dcl commands in sql?

1057