SELECT productid, productname, unitprice, discontinued, CASE discontinued WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' ELSE 'Unknown' END AS discontinued_desc FROM Production.Products;
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
The simple form looks for values in an expression.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/56864/