Question of the day

Question

Post reply

Question of the day

siddharth.tandon1

SSC Journeyman

Points: 95
More actions
January 24, 2013 at 8:38 pm

#269724

Comments posted to this topic are about the item Question of the day

Viewing 15 posts - 1 through 15 (of 38 total)

You must be logged in to reply to this topic. Login to reply

Yogeshwar Phull Default port Points: 1434 More actions · Answer 1

Used these many times but had to read to make sure I get it right. Thanks for the question. +1

Sean Pearce SSCoach Points: 15999 More actions · Answer 2

Nice question, thanks

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

Nice question. Thanks!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

demonfox SSCertifiable Points: 6289 More actions · Answer 4

nice and easy ..

thanks

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

Sean Pearce SSCoach Points: 15999 More actions · Answer 5

I am getting myself confused with some simple maths :crazy:

Answer 1

Coalesce can take more than two parameters, and IsNULL takes exactly two parameters

97%

Answer 5

Coalesce takes exactly two parameters, and IsNULL takes more than two parameters

6%

Does this mean somebody selected these two options as an answer?

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 6

Easy One.. Thanks for the point.

I think few days back had a discussion about data type precedence of COALESCE.

--
Dineshbabu
Desire to learn new things..

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

Nice QtoD. (even though if it looks simple, it is not, makes you think.... 🙂 )

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 8

Easy Friday question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Stuart Davies SSCoach Points: 19505 More actions · Answer 9

Nice and straightforward way to end the week - thanks.

Can't see there'll be much debate about this one!

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Sean Pearce SSCoach Points: 15999 More actions · Answer 10

Stuart Davies (1/25/2013)
Can't see there'll be much debate about this one!

I vehemently disagree.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

manik_anu SSCrazy Points: 2397 More actions · Answer 11

nice question... i am bit confusion about the point "The return type of COALESCE does depend on the data type precedence rules". can u explain any body?????

Manikandan.ps

Move fast as possible...................

Manik
You cannot get to the top by sitting on your bottom.

ma-516002 Hall of Fame Points: 3359 More actions · Answer 12

Good explanation here: http://blogs.msdn.com/b/sqltips/archive/2008/06/26/differences-between-isnull-and-coalesce.aspx

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 13

manik123 (1/25/2013)
i am bit confusion about the point "The return type of COALESCE does depend on the data type precedence rules". can u explain any body?????

See http://msdn.microsoft.com/en-us/library/ms190309.aspx for the data type precedence - the rules that determine the return data type of any operation in SQL Server that combines different data types - except ISNULL, where the return type is always that of the first parameter and the rules of data type precedence don't apply.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 14

manik123 (1/25/2013)
nice question... i am bit confusion about the point "The return type of COALESCE does depend on the data type precedence rules". can u explain any body?????
Manikandan.ps
Move fast as possible...................

Hi manik123

Datat type of the result returned by COALESCE will be highest precedence of all arguments used in the function. So all the arguments used inside Coalesce should be implictly convertible to the highest precedence otherwise u will get a conversion error.

For example.

SELECT COALESCE('abcd',GETDATE())

Will return datatype conversion error.

Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.

Please refer this link for further detail & examples

http://msdn.microsoft.com/en-us/library/ms190349(SQL.105).aspx

--
Dineshbabu
Desire to learn new things..