在线等待!解决散分.....

[hellowang123]

create PROCEDURE quchu_hmd

@return_data varchar(100) output

AS
declare @sqlvar nvarchar(2000)

set @sqlvar = ('select @return_data=count(temp_black.number)
from temp_black,black where temp_black.number=black.number')

exec sp_executesql @sqlvar,N'@return_data varchar(100) output',@return_data output


set @sqlvar=('update black
set black.grade=temp_black.grade
from black,temp_black
where temp_black.number=black.number and
temp_black.grade>black.grade')

exec(@sqlvar)

set @sqlvar=('DELETE temp_black
FROM temp_black INNER JOIN black ON temp_black.number = black.number ')

exec (@sqlvar)

GO

在pb中用
declare pro_pai_hmd procedure for quchu_hmd
@return_data=:ll_return_data output;

execute pro_pai_hmd;

if sqlca.sqlcode = 0 then
fetch pro_pai_hmd into :ll_return_data;
end if
调用为什么update,delete都不执行啊！

[魔鬼代言人5800]

不在PB中执行，在SQLSERVER中执行看看，是否能执行成功！如果不能，说明存储过程有问题，在找原因

[hellowang123]

在SQLSERVER中执行成功！

[polestarxu]

没有commit/rollback吧？

[hellowang123]

COMMIT TRANSACTION 请求没有对应的 BEGIN TRANSACTION。
有这个错误提示
如何开始一个TRANSACTION啊

[hellowang123]

CREATE PROCEDURE quchu_hmd
@return_data varchar(100) output
AS
declare @sqlvar nvarchar(2000)
set @sqlvar = ('select @return_data=count(temp_black.number)
from temp_black,black where temp_black.number=black.number')

exec sp_executesql @sqlvar,N'@return_data varchar(100) output',@return_data output

BEGIN TRANSACTION t_update

set @sqlvar=('update black
set black.grade=temp_black.grade
from black,temp_black
where temp_black.number=black.number and
temp_black.grade>black.grade')

exec(@sqlvar)
commit transaction t_update
BEGIN TRANSACTION t_delete

set @sqlvar=('DELETE temp_black
FROM temp_black INNER JOIN black ON temp_black.number = black.number ')

exec (@sqlvar)

commit transaction t_delete

GO
还是不行

[hellowang123]

那位大虾帮帮忙啊！

[xiao_bai]

你写在前台就是了