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
- 7478 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
Why is replication required on the sql server?
What is built-in function?
What is sqlcmd?
How to use wildcard characters in like operations in ms sql server?
How to remove duplicate rows from table?
Can a database be shrunk with users active?
How to add more data to the testing table in ms sql server?
how can you attach more than 20 ldf files in sql server
What is command parameter in ssrs?
What are the advantages of using stored procedures in sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What are window functions in sql server?
What is indexed view? How to create it?
What do you understand by check constraint in sql server?
What is the importance of a recovery model?
