How to use case statement in ms sql server?
- MS Sql Server
- 291
- August-01-2022
- by Junaid A
How to use case statement in ms sql server?
select
case
when Role_ID=1 then 'admin'
when Role_ID=2 then 'other'
when Role_ID=3 then 'Nine'
end
Role_ID
from RoleInterfaces
