一个多条件查询的例子

Create proc Proc_GetASTInfo  

(  

@keyId int,  

@FCId int,  

@keywords Nvarchar(50),  

@class Nvarchar(50),  

@degree Nvarchar(50)  

)  

as  

declare  

@sql nvarchar(1024)  

set @sql='Select r.id,userid,startendTime,workPlace,working,degree,owner  

From tb_resume r ,tb_userInfo u  

Where  degree ='''+ CONVERT(Nvarchar(50),@degree) +''' and  r.owner=u.id '  

if @FCId>0  

 begin  

 set @sql=@sql+'and class='''+CONVERT(NVARCHAR(50),@class)+''''  

 end  

if @keyId>0  

 begin  

  set @sql=@sql+'and (r.workPlace like ''%'+CONVERT(NVARCHAR(50),@keywords)  

  +'%''or r.working like ''%'+CONVERT(NVARCHAR(50),@keywords)  

  +'%'' or r.status like ''%'+CONVERT(NVARCHAR(50),@keywords)  

  +'%'' or r.startendTime like ''%'+CONVERT(NVARCHAR(50),@keywords)  

  +'%'' or r.degree like ''%'+CONVERT(NVARCHAR(50),@keywords)  

  +'%'' or r.adder like ''%'+CONVERT(NVARCHAR(50),@keywords)  

  +'%'' or r.changer like ''%'+CONVERT(NVARCHAR(50),@keywords)  

        +'%'' or userid like ''%'+CONVERT(NVARCHAR(50),@keywords)  

  +'%'' or r.yearInfo like ''%'+CONVERT(NVARCHAR(50),@keywords)+'%'')'  

 end  

  

exec(@sql)    //必须执行此句