Can you write a Select Case Statement in Transact SQL 3

[SteveRuvolo]

I am trying to use a SELECT CASE Clause in a Tigger and I get an error next to the word CASE

Exampe code:

SELECT CASE @Variable
CASE 'IT'
CODE HERE


CASE 'VEHICLE'
CODE HERE

CASE ELSE

END SELECT

 

[ca8msm]

Your syntax is incorrect. Try reading the help files for the correct syntax.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[bborissov]

SELECT CASE @Variable
            WHEN 'IT'
                 CODE HERE
            WHEN 'VEHICLE'
                 CODE HERE
       ELSE
                 CODE HERE
       END

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[gmmastros]

>> Can you write a Select Case Statement in Transact SQL[/!]

Technically, YES, but not the way you are using it.

It appears as though you want to control the flow of execution, in which case, you cannot use case to do it. You'll need to use IF instead.

[tt][blue]
If @Variable = 'IT'
Begin
CODE HERE
End

Else If @Variable = 'VEHICLE'
Begin
Code Here
End
Else
Begin
Code Here
End
[/blue][/tt]



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

Here's an article by ESquared that explains this better than I can.

http://squaredthoughts.blogspot.com/2007/09/mixed-up-statement-types.html

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom