34,594
社区成员
发帖
与我相关
我的任务
分享
if exists(select * from sysobjects where name ='pp' )
drop Proc pp
go
create proc pp (@str1 varchar(15),@str2 varchar(15),
@str3 varchar(15),@str4 varchar(15))
as
begin
select str_01,str_02,str_03,str_04 from table where str1 like '%'+COALESCE(@str1,'')+'%' or str2 like '%'+COALESCE(@str2,'')+'%' or str3 like '%'+COALESCE(@str3,'')+'%' or str4 like '%'+COALESCE(@str4,'')+'%'
end
exec pp @str1='num1',@str2='num2',@str3='num3',@str4='num4'