Forum Replies Created

Viewing 15 posts - 1,831 through 1,845 (of 3,348 total)

  • RE: CREATE statement

    Hmmm, not sure why some people are so critical about this question. Okay, there is an issue with OBJECT_ID instead of DB_ID in query 2, but other than that the...

    March 11, 2013 at 5:14 am

    #1595461

  • RE: DATETIME - 3

    Good question on a feature that, hopefully, nobody ever relies on anymore. 🙂

    Minor issues: it looks like the distracter options for value 1 and value 2 have been switched, and...

    March 11, 2013 at 4:56 am

    #1595451

  • RE: Can This Work?

    stormcricket (3/6/2013)

    I got it wrong but after a discussion here at work we came up with a possible reason where answer 3 could be correct.

    SSMS returns results on the fly...

    March 9, 2013 at 12:48 pm

    #1595257

  • RE: ISNUMERIC

    L' Eomot Inversé (3/6/2013)

    Nice question, but I don't much like the heading. Fortunately I've learnt not to pay much attention to QotD headings.

    I never look at the headings either,...

    March 6, 2013 at 5:13 am

    #1593887

  • RE: Clustered Index

    Dineshbabu (3/5/2013)

    Hugo Kornelis (3/5/2013)

    Good question, and good explanation. Well done!

    First time I'm seeing Hugo's post without any information.

    Normally, I either post with additional information, or do not post at all....

    March 5, 2013 at 4:26 am

    #1593400

  • RE: Clustered Index

    Good question, and good explanation. Well done!

    March 5, 2013 at 3:29 am

    #1593360

  • RE: Locking Hints

    jholman (3/4/2013)

    Agreed - good question. However the stmt in the explanation is invalid. The alias, 'WTH' was not used in the FROM clause so the SELECT wth.* has...

    March 5, 2013 at 3:24 am

    #1593358

  • RE: SETTINGS - 1

    james.parker 62839 (3/4/2013)

    If it has been such a mess for you for that long, post a correction with the BOL.

    People read and act on the comments made in the...

    March 4, 2013 at 4:08 pm

    #1593209

  • RE: SETTINGS - 1

    Like Tom, I too think the explanation in Books Online is very unsatisfactory. So I did some tests to check a few of the issues.

    In this specific question, two things...

    March 4, 2013 at 1:28 am

    #1592899

  • RE: Can This Work?

    Miles Neale (3/1/2013)

    The code is different from one to the other and thus is either intentional deception or a mistake, take your pick.

    Neither. When errors are corrected after a question...

    March 1, 2013 at 11:57 am

    #1592525

  • RE: Can This Work?

    Steve Jones - SSC Editor (3/1/2013)

    I guess perceptions are different. With the comments noting

    -- first step

    ...

    -- second step

    ...

    I executed each section of code until the next comment, since that...

    March 1, 2013 at 9:03 am

    #1592428

  • RE: Can This Work?

    The idea of the question is nice, but the execution is poor.

    The code as posted will generate a syntax error, because there are no batch seperators. The question text includes...

    March 1, 2013 at 8:20 am

    #1592402

  • RE: Updating the data in a table

    DBA by default (2/28/2013)

    Question: when inserting data into a table I thought it had to be INSERT INTO table VALUES ... but the question is INSERT T1 Values. I guessed...

    February 28, 2013 at 9:57 am

    #1592072

  • RE: Merge

    L' Eomot Inversé (2/28/2013)

    Hugo Kornelis (2/28/2013)

    Coming into this a bit late....

    Another (better, I think) way to explain this, is to think of the USING ... ON as a FULL OUTER...

    February 28, 2013 at 9:40 am

    #1592055

  • RE: Alter User

    L' Eomot Inversé (2/16/2013)

    But I wonder why this strange restriction that alter user can't provide a login for a user who doesn't already have one exists. Presumably MS has...

    February 28, 2013 at 4:29 am

    #1591930

Viewing 15 posts - 1,831 through 1,845 (of 3,348 total)