create procedure pro_bbs @bbsid text as begin declare @userid varchar(50) declare bbs_cursor cursor for select userid from bbs_bbs open bbs_cursor fetch next from bbs_cursor into @userid while @@fetch_status=0 begin update bbs_user set totalcount=totalcount-1 where @userid in (select userid from bbs_bbs where id in (@bbsid) ) fetch next from bbs_cursor into @userid end CLOSE bbs_cursor DEALLOCATE bbs_cursor end go
@bbsid text
as
begin
declare @userid varchar(50)
declare bbs_cursor cursor for select userid from bbs_bbs
open bbs_cursor
fetch next from bbs_cursor into @userid
while @@fetch_status=0
begin
update bbs_user set totalcount=totalcount-1 where @userid in (select userid from bbs_bbs where id in (@bbsid) )
fetch next from bbs_cursor into @userid
end
CLOSE bbs_cursor
DEALLOCATE bbs_cursor
end
go