Can you run ORDER BY after an insert stmt?

[dkillilea]

Is this possible? I have an index on the table, but it's not the way I would typically want to view the table if I SELECT *

I just want the table to be consistent for generic viewing purposes.

Any ideas would be appreciated.

Thank you.

 

[SQLDenis]

ordering of an index is not guaranteed, here is a teaser on this site about that
In order (no pun intended) to order the results in the order that you want to order them by, you need to use order

I mean what is the big deal adding order by..... lazyness?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[SQLDenis]

here is the article that the teaser was based on

http://sqlblog.com/blogs/hugo_kornelis/archive/2006/12/31/Beatles-vs-Stones.aspx

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[mrdenny]

And here is a thread which talks about it thread183-1272512.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLSister]

Oh and I would almost never use select *. It is a bad practice to select more fields than you actually want to see. Best to get in good habits before you run into performance issues.

Questions about posting. See faq183-874