declare @Budget numeric(18,4)
正确用法:
and (Budget is null or Budget=@Budget )
错误用法:
and Budget = null or Budget=@Budget
因为等号不能匹配到null
declare @Budget numeric(18,4)
正确用法:
and (Budget is null or Budget=@Budget )
错误用法:
and Budget = null or Budget=@Budget
因为等号不能匹配到null