declare @fensu int
declare @name nvarchar(50)
set @fensu=74
set @name='张三'
select * from tb where (fensu = @fensu or @fensu is null) and (Name = @name or @name is null)
declare @name nvarchar(50)
set @fensu=74
set @name='张三'
select * from tb where (fensu = @fensu or @fensu is null) and (Name = @name or @name is null)