I'm copying off of Denis Teaser

[monksnake]

What does the following evaluate to and which path does it take??

SELECT CASE 2 WHEN '2' THEN CASE 3 WHEN 2 THEN 5 ELSE CASE 9 WHEN 5 THEN 3 ELSE 0 END END ELSE CASE 0 WHEN 2 THEN 5 ELSE 0 END END

<.

 

[SQLDenis]

should be this 0

Spoiler

CASE 9 WHEN 5 THEN 3 ELSE 0

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

 

[monksnake]

correct!!

<.

 

[AlexCuse]

I think you have a bit too much tiem on your hands over there monksnake!

(says the pot to the kettle ;-) )

Ignorance of certain subjects is a great part of wisdom

 

[monksnake]

I wrote it up in like 2 minutes, actually did it cause I am sick of what I'm doing right now.

<.

 

[AlexCuse]

Here's another one for your amusement:

declare @i integer

select case @i when 0 then 'Is it this answer'
	else 'Or is it this one' end

Ignorance of certain subjects is a great part of wisdom

 

[monksnake]

Spoiler

My knowledge about SQL is limited, but I'm guessing to delcare an integer, it initializes to 0 if nothing is specified, so 'Is it this answer' is my guess.

<.

 

[AlexCuse]

Spoiler

well, you learn something new every day

Ignorance of certain subjects is a great part of wisdom

 

[SQLDenis]

Nope

Spoiler

every declaration is null, which can't be compared since NULL = NULL is no true

unless ansi_nulls is off

Spoiler

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