Coalesce and Conversion

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tom Thomson » Coalesce and Conversion

24 posts, Page 1 of 3

1 2 3 »»»

Coalesce and Conversion

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Monday, January 07, 2013 9:07 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 7,087, Visits: 7,142

Comments posted to this topic are about the item Coalesce and Conversion

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1403953

demonfox

Posted Monday, January 07, 2013 9:12 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074, Visits: 1,076

I missed it completely Sad

. no regret , learned something .

Also, I am glad to see that on aswering the question, equation for right and wrong is 0% and 100 %

Thanks for the question ..

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm

Post #1403955

SQLRNNR

Posted Monday, January 07, 2013 10:07 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

Thanks for the question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1403963

rals

Posted Monday, January 07, 2013 10:34 PM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 1:13 AM
Points: 1,720, Visits: 746

Nice Question. Learnt something for today.

^{Regards,
Rals.}

Post #1403968

Dineshbabu

Posted Tuesday, January 08, 2013 12:13 AM

Right there with Babe

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746, Visits: 435

still now i thought COALESCE will return the datatype of Non NUll value. Today only i learnt it will consider the highest percedence..

Thanks to author for posting nice qstn..

--
Dineshbabu
Desire to learn new things..

Post #1403992

Koen Verbeeck

Posted Tuesday, January 08, 2013 12:31 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

Great and very interesting question. Thanks Tom!

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1403998

Carlo Romagnano

Posted Tuesday, January 08, 2013 1:39 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 12:54 AM
Points: 1,969, Visits: 1,820

I prefer ISNULL, the cast is done to the first argument.
I use it e.g. with numeric type ISNULL(int_null,0). But, I should remember that with string ISNULL may be dangerous as in this case:
declare @c varchar(1)
select ISNULL(@c,'N/D')
Result:
N
instead of N/D

Post #1404046

(Bob Brown)

Posted Tuesday, January 08, 2013 4:12 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 19, 2013 10:27 AM
Points: 690, Visits: 1,100

Thanks for the great question! A true learning question with no controversy.

Post #1404123

Rune Bivrin

Posted Tuesday, January 08, 2013 4:57 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:46 AM
Points: 2,657, Visits: 719

Well, the question is a good one, and I got it right, but if I see code like that I reach for the shot gun.

Just because you're right doesn't mean everybody else is wrong.

Post #1404161

mtassin

Posted Tuesday, January 08, 2013 6:55 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 3,226, Visits: 64,181

Koen Verbeeck (1/8/2013)

Great and very interesting question. Thanks Tom!

+1 I must agree... was a lot of fun to sit there pondering if all of the various data types would be compatible with each other. Now where did I put that Ibuprofen? heh

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems

Post #1404217

« Prev Topic | Next Topic »

24 posts, Page 1 of 3

1 2 3 »»»

Permissions