Multiple CASE conditions in SQL Server

Multiple CASE conditions in SQL Server

We can add multiple case condotions with multiple when and then keywords

Ex :


CASE
WHEN PKID=0 THEN SELECT 1
WHEN PKID=1 THEN SELECT 2
END

You should add END Keyword when you complete your case conditions.