更新表时,发生错误,望各位多多指点.

[昵称已存在0826]

在一张表中,关键字为(DI_ID,EI_ID_Outer,EI_ID_Inner,DC_Outdate),要更新另外两个字段(DC_Innerconfirm和DC_Confirmdate把空变成其他数据),执行下面的存储过程时发生错误.
Create produce p_dc_confirm
(@DID varchar(8),@EIDO varchar(6),@EIDI varchar(6),@Outdate smalldatetime,@Confirmdate smalldatetime)
as
begin
update DC
set
DC_Innerconfirm='已收',DC_Confirmdate = @Confirmdate
where DI_ID=@DID AND EI_ID_Outer=@EIDO AND EI_ID_Inner=@EIDI AND DC_Outdate=@Outdate
end
错误信息如下:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
请问各位高手,这种情况应该怎么解决?小弟先谢谢大家了.

[昵称已存在0826]

补充一下,如果把更新字段,DC_Confirmdate = @Confirmdate 去掉的话,执行没有问题.
单独更新DC_Confirmdate也会出现上面的错误.

[htl258_Tony]

@Confirmdate 这个你外面输入的内容是什么？

[dawugui]

仅从这段代码来看,没看出有什么错误.

Create produce p_dc_confirm 
(@DID varchar(8),@EIDO varchar(6),@EIDI varchar(6),@Outdate smalldatetime,@Confirmdate smalldatetime) 
as 
begin 
update DC 
set 
DC_Innerconfirm='已收',DC_Confirmdate = @Confirmdate 
where DI_ID=@DID AND EI_ID_Outer=@EIDO AND EI_ID_Inner=@EIDI AND DC_Outdate=@Outdate 
end 

或者改为这样:

Create produce p_dc_confirm 
(@DID varchar(8),@EIDO varchar(6),@EIDI varchar(6),@Outdate smalldatetime,@Confirmdate smalldatetime) 
as 
begin 
update DC 
set 
DC_Innerconfirm='已收',DC_Confirmdate = @Confirmdate 
from DC
where DI_ID=@DID AND EI_ID_Outer=@EIDO AND EI_ID_Inner=@EIDI AND DC_Outdate=@Outdate 
end 

[htl258_Tony]

我也是没看出什么错误，在调试时关键字produce 要用 proc

[昵称已存在0826]

输入的是'2009-3-6 0:00:00'和'2009-3-6'两种格式都用了，还是没成功.

[htl258_Tony]

alter proc p_dc_confirm 
(@DID varchar(8),@EIDO varchar(6),@EIDI varchar(6),@Outdate varchar(20),@Confirmdate varchar(20)) 
as 
begin 
update DC 
set 
DC_Innerconfirm='已收',DC_Confirmdate = @Confirmdate 
from DC
where DI_ID=@DID AND EI_ID_Outer=@EIDO AND EI_ID_Inner=@EIDI AND DC_Outdate=@Outdate 
end 

这样试试。

[htl258_Tony]

alter proc p_dc_confirm 
(@DID varchar(8),@EIDO varchar(6),@EIDI varchar(6),@Outdate varchar(20),@Confirmdate varchar(20)) 
as 
begin 
update DC 
set 
DC_Innerconfirm='已收',DC_Confirmdate = cast(@Confirmdate as datetime
from DC
where DI_ID=@DID AND EI_ID_Outer=@EIDO AND EI_ID_Inner=@EIDI AND DC_Outdate=cast(@Outdate as datetime)
end 

如果不行，再这样。

[昵称已存在0826]

多谢您的回答,改成那样也没办法更新.
我在这个表上对DC_Confirmdate字段建立了一个更新触发器,会不会这个触发器的影响?

ALTER trigger t_DC_update
on DC for update
as
if update(DC_Confirmdate)
begin
declare @EID varchar(6),@DID varchar(8),@Department varchar(15),@Indate smalldatetime

update EI_DI
SET DI_Backdate=(select DC_Outdate from inserted) where EI_ID= (select EI_ID_Outer from inserted)
select @EID = EI_ID_Inner from inserted
select @DID = DI_ID from inserted
select @Department =(select EI_Department from EI where EI_ID=@EID)
select @Indate = DC_Confirmdate from inserted

exec p_EI_DI_INS @EID,@DID,@Department,@Indate, Null --调用存储过程

end

[htl258_Tony]

alter proc p_dc_confirm 
(@DID varchar(8),@EIDO varchar(6),@EIDI varchar(6),@Outdate varchar(20),@Confirmdate varchar(20)) 
as 
begin 
update DC 
set 
DC_Innerconfirm='已收',DC_Confirmdate = cast(@Confirmdate as datetime) --sorry,补括号
from DC
where DI_ID=@DID AND EI_ID_Outer=@EIDO AND EI_ID_Inner=@EIDI AND DC_Outdate=cast(@Outdate as datetime)
end 

[htl258_Tony]

[Quote=引用 8 楼 yp314311 的回复:]
多谢您的回答,改成那样也没办法更新.
我在这个表上对DC_Confirmdate字段建立了一个更新触发器,会不会这个触发器的影响?

SQL code
ALTER trigger t_DC_update
on DC for update
as
if update(DC_Confirmdate)
begin
declare @EID varchar(6),@DID varchar(8),@Department varchar(15),@Indate smalldatetime

update EI_DI
SET DI_Backdate=(select DC_Outdate from inserted) where EI_ID= (select EI_ID_Outer f…
[/Quote]没影响，一样会触发。试试吧。

[昵称已存在0826]

非常感谢您的回答,还是报了那个错误.回不回我在那个字段上建立的那个更新出发器影响的?触发器的代码在8楼再次感谢!