你这个语法能通过??
begin end个数都不对!if exists(select name from sysobjects where name ='pingheng_proc' and type= 'P')
begin
drop procedure pingheng_proc
end
go
create procedure pingheng_proc
as
begin
declare @ls_blno char(20),@ls_paichedan char(8)
declare aa cursor for
SELECT paichedan.C_blno,
paichedan.C_paichedanhao
FROM paichedan
open aa
FETCH NEXT FROM aa
into @ls_blno,@ls_paichedan
while @@fetch_status = 0
begin
UPDATE fee_bill
SET C_blno = @ls_blno
WHERE fee_bill.C_paichedanhao = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
UPDATE acc_jiesuan_shifu_tab
SET C_blno = @ls_blno
WHERE acc_jiesuan_shifu_tab.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan UPDATE acc_jiesuan_shifu_tab_copy
SET C_blno = @ls_blno
WHERE acc_jiesuan_shifu_tab_copy.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
UPDATE acc_jiesuan_tab
SET C_blno = @ls_blno
WHERE acc_jiesuan_tab.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
UPDATE acc_jiesuan_tab_copy
SET C_blno = @ls_blno
WHERE acc_jiesuan_tab_copy.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
FETCH NEXT FROM aa
into @ls_blno,@ls_paichedan
end
go
begin end个数都不对!if exists(select name from sysobjects where name ='pingheng_proc' and type= 'P')
begin
drop procedure pingheng_proc
end
go
create procedure pingheng_proc
as
begin
declare @ls_blno char(20),@ls_paichedan char(8)
declare aa cursor for
SELECT paichedan.C_blno,
paichedan.C_paichedanhao
FROM paichedan
open aa
FETCH NEXT FROM aa
into @ls_blno,@ls_paichedan
while @@fetch_status = 0
begin
UPDATE fee_bill
SET C_blno = @ls_blno
WHERE fee_bill.C_paichedanhao = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
UPDATE acc_jiesuan_shifu_tab
SET C_blno = @ls_blno
WHERE acc_jiesuan_shifu_tab.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan UPDATE acc_jiesuan_shifu_tab_copy
SET C_blno = @ls_blno
WHERE acc_jiesuan_shifu_tab_copy.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
UPDATE acc_jiesuan_tab
SET C_blno = @ls_blno
WHERE acc_jiesuan_tab.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
UPDATE acc_jiesuan_tab_copy
SET C_blno = @ls_blno
WHERE acc_jiesuan_tab_copy.C_paichedan = @ls_paichedan
if @@error <> 0
print '出错了'+@ls_paichedan
FETCH NEXT FROM aa
into @ls_blno,@ls_paichedan
end
go
用deallocate释放游标试试
deallocate aa哦。