sqlserver写多条件并列查询语句

ALTER PROCEDURE [dbo].[zq_SearchUser]
@userName varchar(20),
@tel varchar(20),
@email varchar(20)
AS

 declare @sql varchar(1000),@sql1 varchar(1000),@sql2 varchar(1000)
 set @sql='select * from tUser'
 set @sql1=' where 1=1 '
 BEGIN
   if(@userName!='' )
    set @sql1=@sql1+'and userName='+''''+@userName+''''
   if (@tel!='')
       set @sql1=@sql1+' and tel='+''''+@tel+''''
   if (@email!='' )
       set @sql1=@sql1+' and tel='+''''+@email+''''
   set @sql2=@sql+@sql1
   exec(@sql2)

END

 

直接上代码，看不懂就留言！