简单的存储过程，执行没有效果，郁闷，请指点！！

[samzheng]

下边是我的源码
传进去的值都没有问题，就是不执行插入操作,请帮忙!!!
ALTER PROCEDURE dbo.delManufacturer
(
@strMD5 varchar(32)
)
AS
if exists(select * from Manufacturer where MD5 in (@strMD5))
begin
insert into ManufacturerDeleted select MD5,SubItemID from Manufacturer where MD5 in (@strMD5)
end
RETURN

[batisituta]

select * from Manufacturer where MD5 in (@strMD5)
这一句用参数执行有值吗？

[qwbyxw]

加上Print语句在“查询分析器”中测试一下：


if exists(select * from Manufacturer where MD5 in (@strMD5))
begin
insert into ManufacturerDeleted select MD5,SubItemID from Manufacturer where MD5 in (@strMD5)
end

应改为

if not exists(select * from Manufacturer where MD5 in (@strMD5))
begin
insert into ManufacturerDeleted select MD5,SubItemID from Manufacturer where MD5 in (@strMD5)
end

试一下

[batisituta]

你的参数可能存在空格问题，请先用
select @strMD5 = Ltrim(Right(@strMD5))

[batisituta]

抱歉刚才写错了。

你的参数可能存在空格问题，请先用
select @strMD5 = Ltrim(Rtrim(@strMD5))