Forum Replies Created

Viewing 15 posts - 136 through 150 (of 522 total)

  • RE: Duplicate value in Identity column

    ziangij (8/15/2010)

    good one... duplicates can only be avoided by having a constraint in place...

    ...or by having a unique index in place.

    Best Regards,

    Chris Büttner

    August 16, 2010 at 1:25 am

    #1207182

  • RE: How many partitions?

    jeff.mason (8/13/2010)

    Christian Buettner-167247 (8/13/2010)

    Hi,

    I was not sure about the history data. Although the QOTD specified that an average of 20000 rows per month were imported, it did not tell you...

    Best Regards,

    Chris Büttner

    August 13, 2010 at 7:36 am

    #1206625

  • RE: How many partitions?

    Hi,

    I was not sure about the history data. Although the QOTD specified that an average of 20000 rows per month were imported, it did not tell you that all months...

    Best Regards,

    Chris Büttner

    August 13, 2010 at 5:03 am

    #1206507

  • RE: Distinct clause in Select statement

    Nice question, but I think the answer is a little unclear.

    The important thing to note is that the parentheses of the example do not have anything to do with the...

    Best Regards,

    Chris Büttner

    July 26, 2010 at 1:18 am

    #1198043

  • RE: PRINT vagaries

    You are welcome, Open Minded

    Best Regards,

    Chris Büttner

    July 2, 2010 at 12:42 am

    #1188021

  • RE: PRINT vagaries

    Hi Openminded,

    I am not sure what your question is. But here is a transformation of the selects you gave which might be helpful to you.

    Just remember that the unary plus...

    Best Regards,

    Chris Büttner

    July 1, 2010 at 2:32 am

    #1187510

  • RE: PRINT vagaries

    Open Minded (7/1/2010)

    I think MDAS is also followed when there are a bunch of operators between numbers. I guess 'select 6+2+-+7' became 1 happened in this manner:

    • . 6+2+-+7...

      Best Regards,

      Chris Büttner

    July 1, 2010 at 1:52 am

    #1187495

  • RE: PRINT vagaries

    powell_todd (6/30/2010)

    What I'm not quite getting is why "PRINT 6 + 2 + + 7" produces 15, instead of some kind of arithmetic error. I don't think I could...

    Best Regards,

    Chris Büttner

    June 30, 2010 at 7:33 am

    #1187056

  • RE: PRINT vagaries

    kimetch (6/30/2010)

    I was surprised to find that '-' converts to 0. I expected the print statement would have producted "Conversion failed when converting the varchar value '-' to data...

    Best Regards,

    Chris Büttner

    June 30, 2010 at 6:01 am

    #1186990

  • RE: PRINT vagaries

    Nice question, but this is not a "PRINT vagary". Instead this is just how type conversion works (http://msdn.microsoft.com/en-us/library/ms190309.aspx).

    SELECT @lenStringArray + '-' + @lenDelimiter

    behaves the same way, because int (@lenStringArray &...

    Best Regards,

    Chris Büttner

    June 30, 2010 at 12:57 am

    #1186873

  • RE: "SELECT @local_variable"

    ziangij (6/25/2010)

    since there is only one column, why is this working as well ?

    SELECT @t = @t + @comma + a.a

    ,@comma = ','

    FROM #a a

    ORDER BY...

    Best Regards,

    Chris Büttner

    June 25, 2010 at 1:49 am

    #1184834

  • RE: "SELECT @local_variable"

    rajesh.subramanian (6/25/2010)

    Good Question.

    SELECT @t = @t + @comma + a.a

    ,@comma = ','

    FROM #a a

    ORDER BY 1

    Result : C

    SELECT @t = @t + @comma + a.a

    ...

    Best Regards,

    Chris Büttner

    June 25, 2010 at 1:29 am

    #1184823

  • RE: How many Records Will Get Selected

    Hm, looks like I misinterpreted the intention of the author.

    My assumption was, that the question was about whether an error in one of the INSERT operations aborts the full batch....

    Best Regards,

    Chris Büttner

    June 11, 2010 at 1:01 am

    #1179034

  • RE: Bulk-Logged Mode

    Professional question & answer.

    Good start into the day.

    Best Regards,

    Chris Büttner

    June 8, 2010 at 12:55 am

    #1177326

  • RE: HAVING

    High quality, thats what I like in the mornings - Thanks Hugo!

    Best Regards,

    Chris Büttner

    June 7, 2010 at 12:38 am

    #1176946

    • Viewing 15 posts - 136 through 150 (of 522 total)