Forum Replies Created

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

  • RE: Auto Save / Auto recover in Management Studio?

    Thanks,

    This thread just saved me a couple of hours work. From now on I will CTRL+S more often 🙂

    /ah

  • RE: Altering a Column

    Interesting one.

    Thanks.

  • RE: Query Tuning

    Excellent! Question covers a lot.

    Thanks

  • RE: Scaled-down SQL

    Interesting question and a great explanation.

    I learned something, although i got it wrong :)!

  • RE: T-SQL

    Interesting, Thanks.

  • RE: The Percent Sign in T-SQL

    Thanks.

    It would have been nice to have a shortcut for 0/0 (divide zero by zero) :-).

  • RE: CONVERT function

    Thanks.

    Deserves more than 1 point (as do most of the multichoice questions).

  • RE: Disk Is Cheap! ORLY?

    Excellent!

  • RE: T-SQL

    John Mitchell-245523 (12/15/2010)


    I got this right, but I think the question should have been qualified with something like "on an instance installed with the default settings". Otherwise the answer...

  • RE: sys.syscomments

    Can someone please explain why "All of the above" is wrong?

    Does comments refer to something other than inline comments ("--"'s and "/**/"'s)?

  • RE: Varchar or Char?

    Good one!

  • RE: Weird datetime conversions

    mverma4you (5/6/2009)


    your question may lead confusion as you are usign third party tool to write the query. your TSQL include code inside the TSQL statement.

    Hi,

    i cant tell you what...

  • RE: Go go go?

    Actually the "GO"'s at 5 and 8 does nothing but terminates an empty batch (since it is already terminated by the "GO 3"=terminate and run thrice).

    I beleive "GO 3" is...

  • RE: Go go go?

    Try running something like

    SELECT 1 AS A

    GO 3

    This will return three resultset with one row and one column each (containing a 1).

    In the example however,

    GO 3;

    should have ran the...

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