May 11, 2012 at 6:21 am
Good question, I learned something. I got it wrong -- I don't use ISNULL() at all, b/c it seems to me redundant to COALESCE for no added benefit. But, it's used a lot in the world, so I should understand its quirks.
Rich
May 11, 2012 at 6:49 am
Thanks to OP for question - learned something, which is a good way to start the day. I almost always use ISNULL(), unless I need a three or more way test. I prefer the maintenance of the type I was inspecting in almost all cases I can think of.
(Edited to fix typo.)
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
May 11, 2012 at 8:24 am
May 11, 2012 at 8:37 am
Good question and thanks again to Hugo for the clarification. Follows nicely with the SQL Tips article earlier in the week.
http://www.mssqltips.com/sqlservertip/2689/deciding-between-coalesce-and-isnull-in-sql-server/
May 11, 2012 at 9:33 am
A nice one to end the (work)week. Thanks, Robin!
May 11, 2012 at 9:43 am
yippee skippee
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 11, 2012 at 9:47 am
Nice question. Thanks Robin.
May 11, 2012 at 11:03 am
Thanks to the question and to community discussions.
IgorMi
Igor Micev,My blog: www.igormicev.com
May 12, 2012 at 6:28 am
Nice question, thanks Robin. And thanks too to Hugo for his correction of the explanation.
Tom
May 13, 2012 at 10:54 pm
L' Eomot Inversé (5/12/2012)
Nice question, thanks Robin. And thanks too to Hugo for his correction of the explanation.
+1
Thanks
May 13, 2012 at 11:51 pm
nice question, good leaning.
May 17, 2012 at 1:13 pm
Interesting question. Thanks
May 17, 2012 at 8:10 pm
Good question. Thanks for submitting.
http://brittcluff.blogspot.com/
May 22, 2012 at 2:24 am
thanks for the question
Iulian
Viewing 14 posts - 16 through 28 (of 28 total)
You must be logged in to reply to this topic. Login to reply