Viewing 15 posts - 76 through 90 (of 341 total)
SQLRNNR (5/20/2011)
The...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 20, 2011 at 6:44 pm
SQLRNNR (5/20/2011)
SQLRNNR (5/20/2011)
bcsims 90437 (5/20/2011)
SQLRNNR (5/20/2011)
PassedCongrats?
yup - more to come
Congrats!
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 20, 2011 at 1:27 pm
Craig Farrell (5/19/2011)
Interesting discussion....I have to go get it.
Hear, Hear! Well said.
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 20, 2011 at 10:10 am
aaron-403220 (5/19/2011)
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 20, 2011 at 10:08 am
ChazMan (5/19/2011)
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 19, 2011 at 7:38 am
Upon further research, I found this tidbit:
"This is not true for all database implementations. In an Oracle RDBMS for example NULL and the empty string are considered the same thing...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 18, 2011 at 9:00 am
jeff.mason (5/18/2011)
Ugh -- they did it on purpose? For God's sake why? It violates all good database protocol? That really needs to be flagged heavily in BOL.
Yes,...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 18, 2011 at 8:35 am
I just keep wondering how I never heard of STUFF in 12 years working with SQL...
Maybe because people avoid using it for this reason??
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 18, 2011 at 8:33 am
Daniel Bowlin (5/18/2011)
SQLRNNR (5/17/2011)
bcsims 90437 (5/17/2011)
SQLRNNR (5/17/2011)
Brandie Tarvin (5/17/2011)
SQLRNNR (5/17/2011)
Ray K (5/17/2011)
bcsims 90437 (5/17/2011)
Daniel Bowlin (5/17/2011)
SQLRNNR (5/17/2011)
crookj (5/17/2011)
SQLRNNR (5/17/2011)
stickShift
clutch
hitter
pinch
Hmmm, should I spend $60 to take me and my dog to...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 18, 2011 at 8:27 am
Thanks for the easy question. It was so easy I was sure it was some kind of trick 😉
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 18, 2011 at 8:06 am
I spent more time looking at it.
SELECT STUFF('Vinay, Vijay, Amit',8,5,NULL)
is identical result wise to
SELECT STUFF('Vinay, Vijay, Amit',8,5,'') (those are single quotes)
I would never have expected that. I would...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 17, 2011 at 1:47 pm
jeff.mason (5/17/2011)
Logically, NULL plus anything should be NULL. Period, end of story. NULL means "unknown" and you can't assume that you...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 17, 2011 at 1:27 pm
SQLRNNR (5/16/2011)
Peter Trast (5/16/2011)
Brandie Tarvin (5/16/2011)
crookj (5/16/2011)
Ray K (5/16/2011)
WOTD: Rainy day and Monday"Always get me down...."
GAH!
Is that a word?
No, just a horrible song... some 70's music is best forgotten. Hey,...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 16, 2011 at 2:01 pm
Brandie Tarvin (5/16/2011)
Peter Trast (5/16/2011)
Brandie Tarvin (5/16/2011)
crookj (5/16/2011)
Ray K (5/16/2011)
WOTD: Rainy day and Monday"Always get me down...."
GAH!
Is that a word?
No, just a horrible song... some 70's music is best forgotten....
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 16, 2011 at 1:56 pm
SQLkiwi (5/16/2011)
Peter Trast (5/16/2011)
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
May 16, 2011 at 1:55 pm
Viewing 15 posts - 76 through 90 (of 341 total)