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
January 25, 2013 at 12:33 am

This was removed by the editor as SPAM

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: 259105 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: 2377 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/