set identity_insert <table_name> on insert into text1(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 / challa yerriswamy

7 Answers
9306 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / challa yerriswamy

set identity_insert <table_name> on
insert into text1(id,id_name) values(2,'insertedat2')

Is This Answer Correct ?

13 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can a table be created inside a trigger?

1014

How to create nested stored procedure?

1077

How to see existing views in ms sql server?

1115

How to get a list of columns in a view using "sys.columns" in ms sql server?

1044

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1032

How do you rebuild an identity column?

999

How to create a ddl trigger using "create trigger" statements?

1187

What is the difference between migration and upgradation in sql server?

1140

How do I trace a query in sql server?

1002

Will the writetext statement activate a trigger?

1156

How to deploy the Report?

140

how many bits ip address consist of? : Sql server database administration

944

How many types of local tables are there in sql server?

980

What are the Advantages of using CTE in sql server?

1171

What are triggers in ms sql server?

1233