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
- 9052 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / boby
insert into <table_name>(id,name) values(2,'e')ORDER BY ID
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are orphan records?
How to transfer a table from one schema to another?
How to find Duplicate Records In table?
How to drop an existing table with "drop table" statements in ms sql server?
What is clustered vs nonclustered index?
What is store procedure? How do they work?
What are a database and a data warehouse?
How do I trace a query in sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to loop through result set objects using odbc_fetch_row()?
How do I shrink an ldf file?
What are the types of containers in ssis?
What is collation?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
When do you think a developer should use sql server-based cursors?
