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
- 9041 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is temporary stored procedure?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Explain what is sql server english query?
How to provide login information for a new odbc dsn?
Explain primary key in sql server?
What is dirty read?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is implicit cursors?
Explain four layers of abstraction microsoft architectured?
What do you mean by collation recursive stored procedure?
What is the downside of using udf?
Define right outer join?
Tell me what do you understand by a view? What does the with check option clause for a view do?
What is difference between standardization and normalization?
Explain about protocol layer present in SQL server?
