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

How do we Backup SQL Azure Data?

108

Does sql server 2000 full-text search support clustering?

872

How can you insert null values in a column while inserting the data?

1289

What is data source view or dsv? : sql server analysis services, ssas

1008

What is truncate table?

947

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1954

How to create a view on an existing table in ms sql server?

1136

Explain about system database?

1068

Are connections to sql server encrypted?

1010

What happens if the update subquery returns multiple rows in ms sql server?

1130

Explain filtered indexes?

1006

Explain the third normal form(3nf)?

952

What happens if you are trying to access a schema not owned by you?

971

How to concatenate two strings in SQL Server.

1155

what authentication modes does sql server support? : Sql server database administration

1120