ALTER PROCEDURE SP_TEST AS BEGIN if 1=0 SELECT UserName,TrainerID,TrainerInfoID FROM T_TrainerInfo; else select * from T_UserInfo; END GO
MSSQL存储过程1
原文：http://my.oschina.net/0x4ad/blog/413895
