var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Order By Clause
can any one tell me about the difference between the following queries.
1. SELECT * FROM Symp_User ORDER BY
2. SELECT * FROM Symp_User ORDER BY ASC
I don't think there is any difference in the above queries. kinldy make me clear on this.
I think you forgot to mention which field you want to order the result set by
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'BY'.
ASC/DESC are optional operators used in conjunction with the ORDER BY clause. If omitted ASC is assumed.
Last edited by gvee; 09-05-07 at 07:45.
Reason: change highlighted
sorry for the miss out. here is the actual query........
1. SELECT * FROM Symp_User ORDER BY LoginName
2. SELECT * FROM Symp_User ORDER BY LoginName ASC
My question is, whether will there be any Execution Plan difference for the above queries?
Originally Posted by georgev
Last edited by gvee; 09-05-07 at 07:46.
negated??? don't you mean omitted?
Yes, yes I do...
My question is, don't you acces to SQL Server?
I mean it would be very easy to find out if you do, and if you don't, then download the dev version for free