|
Posted by Erland Sommarskog on 10/01/50 11:40
(pkruti@hotmail.com) writes:
> How would i add order by to the syntax below:
>
> "Select * Into ETCLog_holding from etclog where box# BETWEEN " & Box1 &
> " and " & Box2
>
> i have tried adding it after Box2 but it doesnt work.
You can add an ORDER BY clause after Box2, just to be careful to add a
space.
However, it is a fairly pointless thing to do. If you expect data in
ETCLog_holding to have a certain order, you are forgetting the fact
that tables are unordered sets.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|