Viewing 15 posts - 1,336 through 1,350 (of 3,543 total)
Christian Buettner (6/17/2009)
Tom.Thomson (6/17/2009)
Christian Buettner (6/5/2009)
And I had chosen char(1) instead of nchar(1) because...
June 17, 2009 at 5:53 am
Lynn Pettis (6/12/2009)
I already added it to my signature block!
Many more and it will be a full blown reference library :w00t:
btw Excellent article Gail 🙂
June 16, 2009 at 6:48 am
RBarryYoung (6/14/2009)
What shall we name it?
Sad
June 15, 2009 at 2:49 am
Richard M (6/5/2009)
Alvin Ramard (6/5/2009)
Have fun loading Unicode characters in your char(1) column!... well, that's part of the problem, the question did not properly specify the rules of the game.....
...
June 9, 2009 at 7:07 am
Lynn Pettis (6/7/2009)
But if he read the BOL entry for RESTORE FILELISTONLY, why ask the question? :w00t:
To wind you up? :rolleyes:
June 8, 2009 at 2:28 am
Lynn Pettis (6/5/2009)
Here is another OMG moment.
Classic case of RTFM. :doze: It amazes that people do not know or refer to BOL at all. :blink: I have refer to...
June 6, 2009 at 3:09 pm
So there really is no difference between float(25) and float(53). They're both float(53) aka double precision, which is limited to 15 significant digits. Hence the rounding.
Nice one Paul 🙂
Wish I...
June 6, 2009 at 2:37 pm
I'm not sure why it's being rounded up at the 4th decimal spot (yet)
Because if the number is too big, decimals are sacrificed to make it fit
A better...
June 5, 2009 at 6:49 am
The correct construct you were looking for is
WHERE CASE WHEN @Show4 = 'y' AND a.[ID] = 4 THEN 1 WHEN @Show4 = 'n' AND ID 4 THEN 1 ELSE...
June 5, 2009 at 6:41 am
Popup from a trigger?
Sounds a bit Roy Rogers'ish to me :w00t:
June 3, 2009 at 10:12 am
Yes I was going to mention it but since it was in your post I assumed (incorrectly) that the tables were empty.
The message says it all, you cannot add a...
June 3, 2009 at 7:25 am
EXEC @SqlString
should be
EXEC(@SqlString)
June 3, 2009 at 7:11 am
Grant Fritchey (5/28/2009)
GilaMonster (5/28/2009)
I hate dogs. Little ones I just dislike, big ones actually scare me.
Sorry to hear it. I love big dogs. We have an 80lb German Shephard, Maximus....
May 29, 2009 at 1:40 am
Lynn Pettis (5/27/2009)
Here is another OMG moment.
OK, hang on, I'll get my Ouija board and crystal ball :w00t:
May 27, 2009 at 8:39 am
98 bottles of beer on the wall, 98 bottles of beer.
Take one down and pass it around, 97 bottles of beer on the wall.
.....
May 27, 2009 at 8:36 am
Viewing 15 posts - 1,336 through 1,350 (of 3,543 total)