Home » PlItems » Switch / Case Anweisung (T-SQL)

Switch / Case Anweisung

ID118
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangT-SQL
PlGroupKontrollstrukturen
PlItemTitleSwitch / Case Anweisung
Code-- http://msdn.microsoft.com/de-de/library/ms181765.aspx
USE AdventureWorks2008R2;
GO
SELECT ProductNumber, Category =
CASE ProductLine
WHEN 'R' THEN 'Road'
WHEN 'M' THEN 'Mountain'
WHEN 'T' THEN 'Touring'
WHEN 'S' THEN 'Other sale items'
ELSE 'Not for sale'
END,
Name
FROM Production.Product
ORDER BY ProductNumber;
GO
Result Example