NULLS

Question

NULLS

Viewing 14 posts - 16 through 28 (of 28 total)

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

Rich Mechaber SSChampion Points: 11130 More actions · Answer 1

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

Thomas Abraham SSChampion Points: 10761 More actions · Answer 2

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

EL Jerry SSCertifiable Points: 7061 More actions · Answer 3

Good question, had to research a little to get it right.

Have a great weekend!!

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

Cliff Jones SSChampion Points: 10547 More actions · Answer 4

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/

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Revenant

SSC-Forever

Points: 42467

May 11, 2012 at 9:33 am

#1486399

A nice one to end the (work)week. Thanks, Robin!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

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