见鬼了，求救啊，我的SQL条件查询为什么出不来数据啊！！！！！
CREATE PROCEDURE O_TEST
@ReceiveName varchar(100),
@CreateBillDate varchar(20),
@PuctaseContractID int

AS
select * from O_Receive where
(@ReceiveName is null or ReceiveName like '% ' + @ReceiveName + '% ') and
(@CreateBillDate is null or CreateBillDate <= DATEADD(day, 1, @CreateBillDate) ) and
(@PuctaseContractID is null or PuctaseContractID = @PuctaseContractID)


如上，郁闷的很！

[解决办法]
1.
这个 SP 可以 Create 成功吗?


2.
修改版本:

DECLARE
@sql nvarchar(2000),
@Parms nvarchar(2000)

SET @Sql = 'select * from O_Receive where
(@ReceiveName is null or ReceiveName like ' '% ' + @ReceiveName + '% ' ') and
(@CreateBillDate is null or CreateBillDate <= DATEADD(day, 1, @CreateBillDate) ) and
(@PuctaseContractID is null or PuctaseContractID = @PuctaseContractID) '

SET @Parms = '@CreateBillDate varchar(20), @PuctaseContractID int '

sp_executeSql @Sql, @Parms, @CreateBillDate, @PuctaseContractID

3.
先将所有参数传入 NULL 测试是否有数据

Hope helpful!
[解决办法]
查询分析器
exec O_TEST @ReceiveName=‘’，
@CreateBillDate= ' ',
@PuctaseContractID=1
付几个参数试试
，如果没有问题，打开数据库跟踪，跟踪一下