Forum Replies Created

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

  • RE: Precedence in math

    Hmm, don't really see where operator precedence comes in?

  • RE: View - 8

    L' Eomot Inversé (10/8/2012)


    kent_secher (10/8/2012)


    I think the question is not very good, since the correct answer can be deduced without knowledge of indexed views. The successful creation of this unique...

  • RE: View - 8

    I think the question is not very good, since the correct answer can be deduced without knowledge of indexed views. The successful creation of this unique index would depend on...

  • RE: Working on stored procedures

    sam.dahl (8/26/2012)


    Firstly, "I have two stored procedures" suggested to me that the scripts we were executing were the actual stored procedures not necessarily the create scripts depicted.

    That was my interpretation...

  • RE: SELECT options

    Fairly easy question, I think. Hardest part was to sort the data :p

  • RE: Managing Transactions question

    I'm not sure I understand the logic behind the "IF (XACT_STATE()) = 1" part in the catch statement. Do you really want to commit just because you can? 🙂

  • RE: Using SP_

    Koen Verbeeck (12/14/2011)


    Christian Buettner-167247 (12/14/2011)


    Koen Verbeeck (12/14/2011)


    I have a question:

    why doesn't the second 'drop table' statement drop the table in the master database?

    Won't the statement look for the table in...

  • RE: Sorting triggered by data type

    Not only is the explanation incorrect, the answer given as the correct one is in fact also incorrect, since it is not the (explicit) CONVERT function that fails but the...

  • RE: An Impressive SQL Server

    World of Warcraft? 🙂

  • RE: What's Today?

    Disgusting. A quick google revealed that Tax Day could not be the answer. :w00t:

  • RE: Nulls

    Interesting question. But at the least I will have to question the explanation ("If a subquery returns any null value the main query will not return any rows"). If you...

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