Viewing 15 posts - 1,336 through 1,350 (of 3,544 total)
Hugo Kornelis (6/17/2009)
David Burrows (6/17/2009)
But those advocating nchar are also making an assumption :blink:Anyone using nchar on an assumption deserves Pork Chops thrown at them in my view :w00t:
Hi David,
If...
Far away is close at hand in the images of elsewhere.
Anon.
June 17, 2009 at 6:48 am
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...
Far away is close at hand in the images of elsewhere.
Anon.
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 🙂
Far away is close at hand in the images of elsewhere.
Anon.
June 16, 2009 at 6:48 am
RBarryYoung (6/14/2009)
What shall we name it?
Sad
Far away is close at hand in the images of elsewhere.
Anon.
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.....
...
Far away is close at hand in the images of elsewhere.
Anon.
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:
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
June 5, 2009 at 6:41 am
Popup from a trigger?
Sounds a bit Roy Rogers'ish to me :w00t:
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
June 3, 2009 at 7:25 am
EXEC @SqlString
should be
EXEC(@SqlString)
Far away is close at hand in the images of elsewhere.
Anon.
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....
Far away is close at hand in the images of elsewhere.
Anon.
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:
Far away is close at hand in the images of elsewhere.
Anon.
May 27, 2009 at 8:39 am
Viewing 15 posts - 1,336 through 1,350 (of 3,544 total)