create proc wcProc
as
declare @wc nvarchar(30),@rgid nvarchar(30),
@cur cursor,
@job nvarchar(30),
set @cur = CURSOR LOCAL STATIC FOR --设置静态游标
select job,wc,rgid from WC where right(wc,5) <> RIGHT(rgid,5)
OPEN @curs
while(1=1)
begin
fetch next from @cur into @job,@wc,@rgid--按行读取数据
if(@@fetch_status <> 0)--0为读取到数据
begin
break
end
update jrtresource_mst set rgid=( N'GR' + RIGHT(LTRIM( RTRIM( @wc) ) ,5 ) ) where job=@jobend
close @cur--关闭游标
deallocate @cur--释放游标