Posted By

RealRover on 08/07/10


Tagged

case when THEN


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


CASE WHEN ... THEN


 / Published in: SQL
 

  1. CASE
  2. WHEN @RoleTypeId = 0 THEN @RoleTypeName
  3. WHEN @RoleTypeId = 1 THEN 'Public Anonymous User'
  4. WHEN @RoleTypeId = 2 THEN 'System Administrator'
  5. END

Report this snippet  

You need to login to post a comment.