Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-26 : 10:13:38
|
| Shiva writes "HiI want to insert a new row in a table after any specified row and when i open the table in enterprise manage that row must be physically located on specified position.i want to do it only through the query. no stored procedures or triggers.Can u help me out plz?" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-26 : 10:17:53
|
physical order of records has no meaning in SQL Server. You specify the ordering of records you want using the ORDER BY clause.
KH |
 |
|
|
|
|
|
Insert Query