怎么显示当前存储过程执行的进度
有一个存储过程
CREATE PROCEDURE BakCkChange_H
@date1 varchar(10),
@date2 varchar(10)
AS
declare @CKChangeID sysname
/*还料报损*/
declare curCkChange_H cursor for select CKChangeID from dbo.CKChange_History where MakeTime >= ''+ @date1 + '' and MakeTime <= ''+@date2+''
Begin Tran Search
open curCkChange_H
fetch next from curCkChange_H into @CKChangeID
while @@fetch_status = 0
begin
exec('
begin
/*插入*/
insert zaochuan_BAK.dbo.CKChange_History select * from dbo.CKChange_History where CKChangeID = '''+@CKChangeID+ '''
end
')
fetch next from curCkChange_H into @CKChangeID
end
close curCkChange_H
deallocate curCkChange_H
if @@Error<>0
begin
print @@ERROR
Rollback tran Search
return(1)
end
Commit Tran Search
GO
然后在vb里面执行。。
画面上要+个进度条ProgressBar,我要在怎么做 才能使得存储过程执行时的进度个进度条一致阿