Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 8792 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
What are the differences between decimal and float in ms sql server?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How ssrs maintain security?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How sql server executes a statement with nested subqueries?
Explain ranking functions?
How to check table values in sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is the cpu pressure?
Explain steps of normalization?
Why it is recommended to avoid referencing a floating point column in the where clause?
How do I perform an unattended install of sql server 2000?
How to start sql server browser service?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Explain what is lock escalation?
