This blog defines the case statement with a simple example in SQL Server.
--SQL SERVER – CASE Statement- Simple CASE expressions
declare @condition nvarchar(max)
set @condition=1select case @condition
when 1 then 'You have 1 Year Expirence'
when 2 then 'You have 2 Year Expirence'
when 3 then 'You have 3 Year Expirence'
when 4 then 'You have 4 Year Expirence'
when 5 then 'You have 5 Year Expirence'
end
Output
Join the conversation! Your thoughts help the community grow.