DECLARE @Rowid table(rowid int);
BEGIN
set rowcount 100; --一次读取的行数
--先将要读取的记载形态更新
update dbo.T_KeyWord set [IsGet]=0 output deleted.ID into @Rowid Where [IsGet] = 1;
--读取刚更新形态的记载
select * from T_KeyWord where ID in (select Rowid from @Rowid);
END
BEGIN
set rowcount 100; --一次读取的行数
--先将要读取的记载形态更新
update dbo.T_KeyWord set [IsGet]=0 output deleted.ID into @Rowid Where [IsGet] = 1;
--读取刚更新形态的记载
select * from T_KeyWord where ID in (select Rowid from @Rowid);
END