Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: Predict output

    As others have stated, only an ORDER BY guarantees the sort order of the results. Therefore, there are 2 correct answers.

  • RE: References Permission

    Hugo Kornelis (7/23/2008)


    There's a HUGE difference between "Allows the owner of another table to use columns in the table to which they've been granted that permission" (the supposedly "correct" answer...

  • RE: BETWEEN

    Simon Facer (6/4/2008)


    Badly worded question -

    Would statements #1 and #2 consistently return the same result set?

    How do we define "Same Result" Same result as the other statement? Same...

  • RE: Query

    Just adding my voice, too. A date of birth is not a join date.

  • RE: 10/23/07

    John Mitchell (10/23/2007)


    I see. Perhaps points will be refunded in due course.

    The explanation appears to explain why RANK is preferable to DENSE_RANK, but not why it's preferable to the...

  • RE: 10/23/07

    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()...

  • RE: Question of the Day for 14 Jun 2007

    The lesson to be learned today is how to spell "lessen". 

  • RE: Question of the Day for 02 Oct 2006

    Technically, there is a Triggers folder in the Server Objects folder for the server.

  • RE: Specify Execution order of multiple INSERT trigger...

    Check out sp_settriggerorder in the BOL.  You can set only the first and last triggers.

  • RE: Question of the Day for 16 Sep 2005

    Agreed.  There technically is no correct answer.

  • RE: Question of the Day for 01 Sep 2005

    By having to supply a password, you have de facto encrypted it.  You can't use the backup without the password.

  • RE: Question of the Day for 01 Sep 2005

    From the BOL:

    BACKUP DATABASE { database_name | @database_name_var }

    TO < backup_device > [ ,...n ]

    [ WITH

        [ BLOCKSIZE = { blocksize | @blocksize_variable } ]

        [ [ ,...

Viewing 12 posts - 1 through 12 (of 12 total)