where (columnA=@参数 or @参数 is null)where columnA=isnull(@参数,columnA )
大家帮忙看看,为什么这个储存过程会报“关键字 'is' 附近有语法错误。”这样的错误@MemberID int as begin select * from MemberInfo where CASE @MemberID is null then 1=1 else MemberID=@MemberID end
@MemberID int as begin select * from MemberInfo where CASE isnull(@MemberID,'')='' then 1=1 else MemberID=@MemberID end
@MemberID int as begin select * from MemberInfo where CASE when @MemberID is null then 1=1 else MemberID=@MemberID end
谢谢大家,我慢慢知道怎么写了,应该是这样的 where MemberID= CASE when @MemberID is null then MemberID else @MemberID end
不知道还有没有其他的sql里用作判断的???
where @MemberID is null or MemberID=@MemberID where isnull(@MemberID,MemberID)=MemberID ...
declare @MemberID varcharbeginselect * from MemberInfo where MemberID=(CASE when @MemberID is null then MemberID else @MemberID end)end
as
begin
select *
from MemberInfo
where CASE @MemberID is null then 1=1 else MemberID=@MemberID
end
as
begin
select *
from MemberInfo
where CASE isnull(@MemberID,'')='' then 1=1 else MemberID=@MemberID
end
@MemberID int
as
begin
select *
from MemberInfo
where CASE when @MemberID is null then 1=1 else MemberID=@MemberID
end
where MemberID= CASE when @MemberID is null then MemberID else @MemberID end
where isnull(@MemberID,MemberID)=MemberID
...
declare @MemberID varcharbeginselect *
from MemberInfo
where MemberID=(CASE when @MemberID is null then MemberID else @MemberID end)end