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
- 7933 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
How can sql server instances be hidden? : sql server security
What is sql server english query?
How will you go about resolving deadlocks?
Do you know hot add cpu in sql server 2008?
How to create a login account in ms sql server to access the database engine using "create login" statements?
How do you start single user mode in clustered installations?
What is the significance of master, tempdb and model databases?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
what is a sub-report?
Explain the truncate command?
What is temporary table in sql server? Why we use temp table?
What is temporal data type?
List out the difference between union and union all in sql server?
What are the different types of normalization?
When to use null data driven subscription?
