--删除语句 declare test cursor for select top 10 ID from test1 order by ID asc declare @ID nvarchar(10) open test fetch next from test into @ID while @@fetch_status=0 begin delete from test1 where ID=@ID fetch next from test into @ID end close test deallocate test --更新UPDATE语句 declare test cursor for select top 50 ID from test1 order by ID declare @ID nvarchar(10),@ID2 int open test set @ID2=0 fetch next from test into @ID while @@fetch_status=0 begin SET @ID2 = @ID2 + 1 update test1 set keyname=Cast(@ID2 as nvarchar(10)) where ID=@ID fetch next from test into @ID end close test deallocate test go