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

explain different types of cursors? : Sql server database administration

1145

Explain what are commit and rollback in sql?

981

What are different types of roles provided by ssrs?

156

How to write a query with a full outer join in ms sql server?

1156

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

127

How can you check the level of fragmentation on a table?

1087

Do you know exporting and importing utility?

1104

What are system databases in ms sql server?

1122

What are commonly used mssql functions in php?

1141

How to create a simple stored procedure in ms sql server?

1084

Is it possible for a stored procedure to call itself or recursive stored procedure?

1003

How to add a new dsn with the odbc driver for sql server?

1112

What is explicit cursors?

1123

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1038

Can you create a logon trigger in sql server 2005 express edition?

1119