Viewing 12 posts - 1 through 12 (of 12 total)
As others have stated, only an ORDER BY guarantees the sort order of the results. Therefore, there are 2 correct answers.
October 14, 2008 at 4:33 am
Hugo Kornelis (7/23/2008)
July 23, 2008 at 5:52 am
Simon Facer (6/4/2008)
Would statements #1 and #2 consistently return the same result set?
How do we define "Same Result" Same result as the other statement? Same...
June 5, 2008 at 3:14 pm
John Mitchell (10/23/2007)
The explanation appears to explain why RANK is preferable to DENSE_RANK, but not why it's preferable to the...
October 23, 2007 at 4:19 pm
Agreed - the real correct answer is RANK(). If two people are tied for 1st, the next one is technically 3rd, since 2 are ahead of him/her. ROW_NUMBER()...
October 23, 2007 at 4:32 am
The lesson to be learned today is how to spell "lessen".
June 14, 2007 at 5:04 am
Technically, there is a Triggers folder in the Server Objects folder for the server.
October 2, 2006 at 4:49 am
Check out sp_settriggerorder in the BOL. You can set only the first and last triggers.
March 20, 2006 at 9:02 am
Agreed. There technically is no correct answer.
September 16, 2005 at 5:44 am
By having to supply a password, you have de facto encrypted it. You can't use the backup without the password.
September 1, 2005 at 6:32 am
From the BOL:
BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ ,...
September 1, 2005 at 5:23 am
Viewing 12 posts - 1 through 12 (of 12 total)