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

What is the syntax for encrypting a column in SQL Server?

1120

How to create user defined functions with parameters?

1236

What are the filtered indexes?

1040

What is the meaning of sql server?

986

How to create stored procedures with parameters in ms sql server?

1079

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1044

how can u get last observation in an unknown dataset ?

2436

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1750

What are the differences between char and varchar in ms sql server?

1066

What are indexers?

1086

What is dirty read?

1080

Explain powershell included in sql server 2008?

1057

What is faster join or union?

1213

What are the different types of sql server replication? : sql server replication

1273

What is query parameter in ssrs?

160