ORDER BY

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kev Riley » ORDER BY

183 posts, Page 1 of 19

1 2 3 4 5 »»»

ORDER BY

Rate Topic

Display Mode

Topic Options

Author

Message

kevriley

Posted Saturday, March 29, 2008 4:08 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:29 AM
Points: 2,677, Visits: 2,277

Comments posted to this topic are about the item ORDER BY

Post #476622

pipe

Posted Saturday, March 29, 2008 10:39 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 10:07 AM
Points: 481, Visits: 43

Hi,
I think question and answer aren't synchronous.

If it is question for SQL 2005 Server then good answer is:
"Msg 208, Level 16, State 1, Line 1
Invalid object name 'Employee'."

If your default Schema is not Schema to which employee table belongs.

If it is question for SQL 2000 Server (what syntax suggest :)) then good answer is:
"All columns and all rows from the employee table in descending start_date order, with the start_date as the first column"

Post #476669

gbpthomas

Posted Sunday, March 30, 2008 1:40 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, August 25, 2008 9:56 PM
Points: 843, Visits: 38

For SQL SERVER 2000 it will work

Post #476678

DeadWood

Posted Sunday, March 30, 2008 1:53 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, October 04, 2012 12:06 PM
Points: 326, Visits: 133

For SQL Server 2000 the statement will succeed... For SQL 2005 you need to qualify the Order by statement with the table name. This question should have been written more clearly.

Thanks
Un happy Member (I answered it from a 2000 point of view)

Thanks

Post #476724

Iggy-SQL

Posted Sunday, March 30, 2008 4:56 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:40 PM
Points: 2,883, Visits: 411

The question doesn't specifically mentioned this is for SQL Server 2005, so I think we SQL Server 2000 users deserve some credit for answering "A" :D

Urbis, an urban transformation company

Post #476740

Mr. DBA

Posted Sunday, March 30, 2008 11:29 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, March 14, 2012 12:32 AM
Points: 491, Visits: 39

Dear Friend,

Please provide all the information about the situtation and/or enviorment :).
It will work perfectly fine with SQL Server 2000.:D
But not with SQL Server 2005.

Thanks.

Regards,

Post #476781

far

Posted Sunday, March 30, 2008 11:41 PM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 10:25 AM
Points: 3,510, Visits: 116

Hi all

The suggested Answer is wrong

Post #476782

dragos_sv

Posted Monday, March 31, 2008 1:02 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 798, Visits: 986

i do not think it's a matter of sql server version. ideally you/we should be able to answer without running the command.
but if you still want to run it, no one prevents you from adapting the script to match your (test) environment, table names, column names... etc

dragos

Post #476801

Jason Campbell-349945

Posted Monday, March 31, 2008 1:03 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, June 09, 2013 1:31 PM
Points: 86, Visits: 123

This works OK in SQL server 2000.

The question didn't specify which SQL version.

Cool

Post #476802

majorbloodnock

Posted Monday, March 31, 2008 1:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 10:52 AM
Points: 1,043, Visits: 2,945

Hmm.

We have a multiple guess question that asks, "if you do this, what'll happen?". There isn't an option for, "in some situations this, in others that", so either there are two right answers or there aren't any.

Unfortunately, the QOTD, whilst only being a bit of fun (and good fun at that), suffers from rather frequent bad phrasing. I suspect Steve simply hasn't the time for the required level of sanity-checking.

Semper in excretia, sumus solum profundum variat

Post #476812

« Prev Topic | Next Topic »

183 posts, Page 1 of 19

1 2 3 4 5 »»»

Permissions