Case with NULL

#11

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:

Quote:

On Fri, 14 Jan 2011 23:13:32 +0100, Erland Sommarskog
esquel (AT) sommarskog (DOT) se> wrote:

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
Not the adjective I would have picked.

You're not Swedish, are you? :-)

No, why?

Had you been Swedish you would have not been a native speaker of English.
And less accurate in your picking of adjectives.

Quote:

When you use CASE, you easier realise that the subquery is computed
twice.

And only once with coalesce() which would argue in favour of
using it. (Naturally, all bets are off when optimisation enters the
picture.)

No, the point is that coalesce is rewritten to the CASE experssion
internally before optimization, so the two are identical.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Case with NULL

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: Case with NULL - 01-17-2011 , 02:44 AM