like '%'+rtrim(@para1)+'%'
CREATE proc p_select
@para1 nvarchar(50)=null,
@para2 nvarchar(200) =null
as
select * from users
where(@para1 is null or userName like '%' + @para1 +'%')
and (@para2 is null or techArea = @para2)
CREATE proc p_select
@para1 nvarchar(50)
@para2 nvarchar(200)
as
begin
select * from users
where
userName like ('%'+@para1+'%')
and techArea like ('%'+@para2+'%')
end
-----------
%是通配符
exec p_select @para1 ='',@para2=''
查询全部
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024