6.case-2-example.sql

SQL Server 2005基础教程一书的源代码.

SELECT CustomerId,
CASE  
WHEN ClearedBalance < 0 THEN 'OverDrawn'
WHEN ClearedBalance > 0 THEN ' In Credit'
ELSE 'Flat'
END, ClearedBalance
FROM CustomerDetails.Customers