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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / qwerty
set identity_insert <table_name> on
insert into <table_name>(id,name) values(2,'e')
set identity_insert <table_name> off
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / sunilkumar
set identity_insert on
insert into test1(Id ,id_name) values (2 ,'insertedat2')
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / boby
insert into <table_name>(id,name) values(2,'e')ORDER BY ID
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pradeep aryan
set identity_insert on
insert into test1(Id ,id_name) values (2 ,'e')
set identity_insert off
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / 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 |
What is query processing?
Explain foreign key in sql server?
What is dynamic cursor in SQL SERVER?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
5 Answers Aptech, HCL, Perpetual, SAIC,
What is a field name?
Explain the categories of stored procedure?
What is Self Join?
What are scalar functions in sql?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue
what are the Prerequisites for Replication?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)