Posts
242
Comments
66
Trackbacks
4
Select Case in stored procedure

Eigentlich mehr fürs Archiv, Select Case in stored procedure:

            SELECT @gb = CASE
                WHEN @zaehler = 1 THEN 'GB 1'
                WHEN @zaehler = 2 THEN 'GB 2'
                WHEN @zaehler = 3 THEN 'GB 3'
                WHEN @zaehler = 4 THEN 'GB 4'
                WHEN @zaehler = 5 THEN 'GB 5'
            END

posted on Wednesday, February 21, 2007 8:55 AM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 8 and 4 and type the answer here: