AI摘要
本文介绍了如何在MSSQL中使用游标进行多参数循环操作，以提高效率。通过创建一个存储过程，声明变量并使用游标查询具有相同电话号码和主ID但有多个记录的记录。然后，通过循环操作，删除除了最小ID之外的所有记录。最后，关闭并释放游标。
本文介绍了如何
游标多参数循环操作，效率确实高了不少。
CREATE PROCEDURE p AS
declare @UserID int
declare @MinID int
declare @UserTEL varchar(20)
declare cur_getUserID cursor for
select main_id,tel,min(id) from tel group by tel,main_id having count(*)>1
--select main_id,tel,min(id) from tel where main_id=962192 and tel='15882188374' group by tel,main_id
open cur_getUserID
fetch next from cur_getUserID into @UserID,@UserTEL,@MinID
while(@@fetch_status = 0)
begin
delete from tel where main_id=@UserID and tel=@UserTEL and id<>@MinID
fetch next from cur_getUserID into @UserID,@UserTEL,@MinID
end
close cur_getUserID
deallocate cur_getUserID
GO