Site Sections
Posts
391
Comments
137
Trackbacks
0
<< kostenloser MediaPlayer | Home | Typisierte Resource-Dateien mit öffentlichen (public) Properties erzeugen >>
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 7 and 1 and type the answer here:
Archives
Post Categories
test