SQL SERVER2008 CASE WHEN的两种用法

SELECT
CASE 
	WHEN COLUMN_NAME1 = VALUE1 AND COLUMN_NAME2 = VALUE2 
		THEN  VALUE_WANTED1
	ELSE
		VALUE_WANTED2
END,
 * FROM TABLE_NAME

SELECT
CASE COLUMN_NAME1 
	WHEN VALUE1 THEN VALUE_WANTED1 
	WHEN VALUE2 THEN VALUE_WANTED2
	ELSE
		VALUE_WANTED3
END,
 * FROM TABLE_NAME