1 USE [exercise] 2 GO 3 /****** Object: StoredProcedure [dbo].[procstudent] Script Date: 11/10/2013 23:09:33 ******/ 4 SET ANSI_NULLS ON 5 GO 6 SET QUOTED_IDENTIFIER ON 7 GO 8 ALTER PROCEDURE [dbo].[procstudent] 9     @s int,10     @c int11  12 AS13 BEGIN14  SET NOCOUNT ON;15 declare @sql varchar(300),16     @sex nchar(10),17  @class nchar(10)18   set @sql=‘select number,name,sex,class from table1 where 1=1‘19 IF @s=120    begin21    set @sex=‘男‘22    end23 IF @s=224    begin25    set @sex=‘女‘26    end27    28 IF @s<>029    begin30    set @sql=@sql+‘ and sex=‘+‘‘‘‘+@sex+‘‘‘‘31    end32 IF @c=133    begin34    set @class=‘1‘35    endm36 IF @c=237    begin38    set @class=‘2‘39    end40 IF @c<>041    begin42    set @sql=@sql+‘ and class=‘+@class43    end44    print @sql45    exec(@sql)46 END