Friday Teaser NULL vs COALESCE

[SQLDenis]

Without running the code, try to guess the output

DECLARE @v1 VARCHAR(3)
DECLARE @i1 INT


SELECT  ISNULL(@i1, 15.00) /2, 
      COALESCE(@i1 , 15.00) /2,
      ISNULL(@v1, 'Teaser #2'), 
      COALESCE(@v1, 'Teaser #2')

I hope you will use COALESCE instead of ISNULL from now on ;-)



Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com
Google Interview Questions

 

[ptheriault]

Spoiler

Here is my guess.

7
7.50
fail
Tea

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

Almost!

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[AlexCuse]

I would not have known had I not run into this problem before.

Spoiler

7
7.5
Tea
Teaser #2

Ignorance of certain subjects is a great part of wisdom

 

[monksnake]

Hmmmm, my try:

Spoiler

can't make Null into type decimal
divide by 0 error
Teaser #2
Can't convert type varchar to type int

<.

 

[monksnake]

I bombed that.

<.

 

[Lamprey13]

That is why I try to convince people to get in the habbit of always using COALESCE. That and ASNSI compliance.