Viewing 15 posts - 121 through 135 (of 230 total)
One trillion integers won't fit in an INT column so a...
September 26, 2017 at 8:01 am
September 26, 2017 at 7:50 am
Interesting. However, the question doesn't actually say if those are one trillion different integers, or if there are repetitions. If there are one trillion different values, I doubt there will...
September 26, 2017 at 12:32 am
These questions certainly require a fair bit of mind reading to get "correct". But remembering the debacle from the previous installment and the following discussion, CEILING will accomplish what Steve...
August 22, 2017 at 1:15 am
Doh! I missed the "Distributed" part of the heading. There's nothing in the docs about regular replay that says anything about versions for replay targets.
August 17, 2017 at 4:48 am
Have to agree with the above. I have to admit I didn't really understand what Steve was trying to achieve, but I still got points because that was the only...
July 31, 2017 at 2:17 am
Nice try...
Quite interestingly, not even the link to the supporting MSDN article is correct.
February 8, 2017 at 3:16 am
Russell Shilling (1/10/2017)
The
isnull(left(@b,3),'I ô Char') as ba
will also return the string. The left function of @b-2...
January 10, 2017 at 11:34 pm
Thank you very much, Uwe!
That was a very enlightening question and explanation. Definitely something to add to the tool belt for those pesky edge cases.
January 5, 2017 at 3:47 am
Not quite sure I agree with the answer. There is a difference between what I must do and what I should do. According to the quoted article you do not...
October 28, 2016 at 12:54 am
barry.mcconnell (10/11/2016)
Interestingly, if you examine Information Schema Columns, the table only has 3 columns.
I'd be a lot more surprised if there were more columns than that. Without a name or...
October 11, 2016 at 7:40 am
Viewing 15 posts - 121 through 135 (of 230 total)