可能是游标类型不对
create table #a(a varchar(10))
insert #a select 'a' union all select 'b' union all select 'a' union all select 'b' union all select 'c'
-----------------------------------------------------------
declare a cursor local scroll_locks for select * from #a
open a
declare @b varchar(10)
fetch a into @b
while (@@fetch_status=0)
begin
if @b='b'
delete #a where current of a
fetch a into @b
end
close a
deallocate a
------------------------------------------------------------
select * from #a