Transact SQL 101 - Lesson 10_01_SQL.txt

(0 KB) Pobierz

use adventureworkslt
GO

--Example 1		
SELECT stateprovince, countryregion,
	CASE countryregion
		WHEN 'United States' THEN 'USA'
		WHEN 'Canada' THEN 'CAN'
	END AS 'Country'
FROM saleslt.address

SELECT stateprovince,
	CASE countryregion
		WHEN 'United States' THEN 'USA'
		WHEN 'Canada' THEN 'CAN'
		ELSE 'Somewhere Else'
	END AS 'Country',
	PostalCode
FROM saleslt.address

--Example 2
SELECT productnumber, [size], 'Size Detail' = 
	CASE [size]
		WHEN 'M' THEN 'Medium'
		WHEN 'S' THEN 'Small'
		WHEN 'L' THEN 'Large'
		WHEN 'XL' THEN 'Extra Large'
		ELSE [size]
	END
FROM saleslt.product	

--Example 3
SELECT productnumber, Weight, 'Shipping Notes' =
	CASE
		WHEN Weight > 1000 THEN 'Heavy'
		WHEN Weight BETWEEN 500 AND 1000 THEN 'Medium'
		WHEN Weight < 500 THEN 'Light'
		ELSE 'Weight Unknown'
	END
FROM saleslt.product

Transact SQL 101 - Lesson 10_01_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: