|
Comments
|
|
Very useful!
|
|
|
instead of COALESCE, can we use isnull?
|
|
|
This was very good and exposed me to a couple of new verbs.
|
|
Carla Wilson on
4/13/2009
Good examples. Thanks.
|
|
|
Very clear and concice. The NULLIF T-SQL fcn explained well. The breakdown of the COALESCE function could have been better
|
|
|
simple
|
|
|
What is the difference in using NULLIF instead of ISNULL?
|
|
|
I can use this today! How handy!
|
|
|
Mahesh, I think they are equivalent in this case. Coalesce would shine where you had multiple values and wanted SQL to return the first null instead of only one value to return if null. But if it were me, I'd try both and compare the performance, as that might be the difference!
Paul, I think the difference is that NULLIF returns a null when a condition is met and ISNULL is used when you want to return something else instead of the null.
|
|
|
Paul, I think the difference is that NULLIF returns a null when a condition is met and ISNULL is used when you want to return something else instead of the null. (Sorry, repeating for clarity)
|
|
|
Great.
|
|
|
Mahesh, as noted by Holck you can use ISNULL instead of COALESCE. There are some differences between the functions but the logic here will not be affected. COALESCE is in ANSI SQL and this is why I prefer to use it.
|
|
|
I learn something today.
|
|
|
VEry usefull and interesting
|
|
|
clever, usefull video
|
|
|
short and nice describing video that gave me the info I needed within minutes
|
|
|
Good to know.
|
|
|
Very helpful. Answered a problem I was having at this very moment.
|
|
|
Simple to think But had No idea till Now..
|
|
|
excellent alternative to using case!!
|
|
|
Good
|
|
|
Very helpful!
|
|
|
Good learning for us beginners... Thanks.
|
|
|
Great tip.
|
|
|
Excellent video. Useful and to the point.
|
|
|
could you also have used the ISNULL function instead of the COALESCE
|
|
|
useful tip
|
|
|
Good info! I would like the see the difference in the execution plan between nullif and case... would the performance be similar?
|
|
|
Great video. This is exactly the kind of thing I came here for :)
|
|
|
I've always wanted to know how to use NULLIF()...now I know. Thanks Great Video!!!
|
|
|
Very interesting approach.
|
|
|
this is a common error I experience. thanks!
|
|
|
coalesce good thought
|
|
|
Excellent video presentation. Easy to follow and great reduction in coding.
|
|
|
no need to see how to create a table and insert rows
|
|
|
Nice, I like it!
|
|
|
It was short and nice video.
|
|
|
good dude.
|
|
|
Great content! ;)
|
|
|
Good video!
|
|
|
Excellent tutorial
|
|
|
Very interesting and usefull to know. Thanks!!!
|
|
|
thanks it great
|
|
|
Nice.Beats the CASE statement anyday.
|
|
|
good info - accent hard to understand tho
|
|
|
I learnt new thing today COALESCE and NULLIF. Thank you very much. It was brief and clear. It suits my style of studying!!!!!
|
|
|
What a great video with all those examples!
|
|
|
Very useful methods to write compact, efficient statments.
|
|
|
Good job explaining. Nice and slow and thorough!
|
|
|
just what I was looking for!
|
|
|
excxellent
|
|
Maurice Ivory on
2/16/2012
It was cool but my video skipped and I misse important information.
|