摘要：使用过SQL Server的人相信都熟悉Case的用法，它通常被用来做条件判断，比如对于如下表：CREATE TABLE Student(name NVARCHAR(64) NOT NULL, type INT NULL --1为党员，2为团员)INSERT INTO Student VALUES(N'小张', 1)INSERT INTO Student VALUES(N'小李', 2)INSERT INTO Student VALUES(N'小王', 2)INSERT INTO Student VALUES(N'小刘', 1)INSERT INTO Student VALUES(N'小杨', 阅读全文