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
9060 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 to specify the collation for a character data type in ms sql server?

1030

What are the different types of normalization?

1167

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2752

What is difference between count (*) and count 1?

929

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1137

What is sql injection and why is it a problem? : sql server security

1132

What are the advantages of using a stored procedure?

1008

Do you know the cursor types?

1156

what purpose does the model database serve? : Sql server database administration

977

Explain subquery and state its properties?

1042

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

Explain the different types of joins?

997

What are wait types?

1114

What do you mean by collation recursive stored procedure?

1056

Is sql server free?

917