假设我在视图中有以下SELECT语句(SQL Server 2008):
SELECT (SELECT CASE
WHEN HISTORY.OUTOFSERV = 'Y' OR HISTORY.OUTOFSERV = 'y' THEN 1
ELSE 0
END) AS OOS
FROM HISTORY
еҲ—OOSжңҖз»ҲжҲҗдёәintзұ»еһӢпјҢдҪҶжҲ‘еёҢжңӣе®ғжҳҜbitзұ»еһӢгҖӮжҲ‘иҜҘеҰӮдҪ•е®һзҺ°пјҹ