Viewing 15 posts - 136 through 150 (of 521 total)
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.
August 16, 2010 at 1:25 am
jeff.mason (8/13/2010)
Christian Buettner-167247 (8/13/2010)
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...
August 13, 2010 at 7:36 am
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...
August 13, 2010 at 5:03 am
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...
July 26, 2010 at 1:18 am
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...
July 1, 2010 at 2:32 am
Open Minded (7/1/2010)
. 6+2+-+7...
July 1, 2010 at 1:52 am
powell_todd (6/30/2010)
June 30, 2010 at 7:33 am
kimetch (6/30/2010)
June 30, 2010 at 6:01 am
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 &...
June 30, 2010 at 12:57 am
ziangij (6/25/2010)
SELECT @t = @t + @comma + a.a
,@comma = ','
FROM #a a
ORDER BY...
June 25, 2010 at 1:49 am
rajesh.subramanian (6/25/2010)
SELECT @t = @t + @comma + a.a
,@comma = ','
FROM #a a
ORDER BY 1
Result : C
SELECT @t = @t + @comma + a.a
...
June 25, 2010 at 1:29 am
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....
June 11, 2010 at 1:01 am
Professional question & answer.
Good start into the day.
June 8, 2010 at 12:55 am
Viewing 15 posts - 136 through 150 (of 521 total)