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
8802 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 order of B+tree?

1063

how many type of indexing in database?

937

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

885

how can you check the level of fragmentation on a table? : Sql server administration

921

How to start and end transact-sql statements?

971

What is user-defined inline table-valued function?

900

What is mean by candidate key?

949

What happens when transaction log is full?

873

What is sub-query in sql server? Explain its properties.

1043

Explain for xml explicit mode?

913

Explain cdc and sql injection?

913

Explain what are the restrictions that views have to follow? : SQL Server Architecture

993

What is bookmark link in ssrs?

234

What are trace flags and mention a few common trace flags used with sql server?

1039

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1014