Control of Flow - where is CASE ?

Question

Post reply

Control of Flow - where is CASE ?

mar.ko

Default port

Points: 1451
More actions
September 18, 2015 at 1:04 pm

#303193

Why isn't CASE supported for flow control in T-SQL ?
I have to do this ?:
IF @xyz = 1 THEN
EXEC dbo.PROC1
ELSE IF @xyz = 2 THEN
EXEC dbo.PROC2
ELSE
EXEC dbo.PROC3
END

Viewing 5 posts - 1 through 4 (of 4 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Because T-SQL doesn't like to have flow control.

Don't forget to remove THEN, this isn't VB. 😛

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

mar.ko Default port Points: 1451 More actions · Answer 2

Luis Cazares (9/18/2015)
Because T-SQL doesn't like to have flow control.

Why exactly ?

BTW: Thanks for that "THEN" but IMHO that should be optional.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Unlike Oracle where CASE can be used for control of flow, T-SQL does not have it overloaded in that manner. Why? I don't know, you'd actually need to go back Sybase Engineers to figure that one out.

autoexcrement SSCertifiable Points: 5956 More actions · Answer 4

You can use this type of conditional logic in stored procedures. Dunno if that's stating the obvious or not.

"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura