34,499
社区成员
发帖
与我相关
我的任务
分享执行存储过程发现一个怪问题？
在程序中执行一个存储过程，99％以上都有执行，偶而有一定时段不执行，然后用手动用sql客户执行，提示“数据库出现致命错误，请与管理员联系",请问各位高手这是什么问题?
...全文
请发表友善的回复…
发表回复
jhl_hong 2003-12-19
- 打赏
- 举报
up
forestjiang 2003-12-02
- 打赏
- 举报
up
jhl_hong 2003-11-26
- 打赏
- 举报
存储过程如下：
CREATE PROCEDURE proc_wl_jhrk_js
(
@rkdh varchar(10),
@yhbh varchar(10)
)
AS
delete from up_zbkcb where yhbh = @yhbh
insert up_zbkcb (cpbh,kcsl,yhbh)
select cpbh,sum(sl),@yhbh from wl_cprk_list where rkdh = @rkdh
group by cpbh
update shop_list set lks = isnull(lks,0)+ a.sl
from wl_cprk_list a,shop_list b where a.rkdh = @rkdh and a.cgdh = b.cgdh and a.cpbh = b.cpbh
update zbkcb
set zbkcb.kcsl = isnull(zbkcb.kcsl,0) + up_zbkcb.kcsl
from up_zbkcb,zbkcb where up_zbkcb.cpbh = zbkcb.cpbh and kw = '01' and kb = 'A' and up_zbkcb.yhbh = @yhbh
return 0
CREATE PROCEDURE proc_wl_jhrk_js
(
@rkdh varchar(10),
@yhbh varchar(10)
)
AS
delete from up_zbkcb where yhbh = @yhbh
insert up_zbkcb (cpbh,kcsl,yhbh)
select cpbh,sum(sl),@yhbh from wl_cprk_list where rkdh = @rkdh
group by cpbh
update shop_list set lks = isnull(lks,0)+ a.sl
from wl_cprk_list a,shop_list b where a.rkdh = @rkdh and a.cgdh = b.cgdh and a.cpbh = b.cpbh
update zbkcb
set zbkcb.kcsl = isnull(zbkcb.kcsl,0) + up_zbkcb.kcsl
from up_zbkcb,zbkcb where up_zbkcb.cpbh = zbkcb.cpbh and kw = '01' and kb = 'A' and up_zbkcb.yhbh = @yhbh
return 0
zblaoshu1979 2003-11-26
- 打赏
- 举报
up一下，没出现过这样的问题
erigido 2003-11-26
- 打赏
- 举报
up,帮你顶
CrazyFor 2003-11-26
- 打赏
- 举报
你的存储过程的代码??
jhl_hong 2003-11-26
- 打赏
- 举报
上面的问题出现后，过一段时间再执行又正常了，郁闷中....有那位高手知道呀
jhl_hong 2003-11-26
- 打赏
- 举报
没人顶
