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
- 9027 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is normalization and denormalization in sql server?
How to divide query output into multiple groups with the group by clause in ms sql server?
Which table keeps information about stored procedures?
List few advantages of stored procedure.
How to search for a string in all stored procedure in sql server?
What is simple indexing method?
What is 1nf 2nf and 3nf?
How many types of subqueries are there in sql server?
What is a scheduled job or what is a scheduled task?
Explain primary key?
In how many ways you can invoke ssrs reports?
What is difference between view and materialized view?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
How to check table values in sql server?
What is acid properties?
