如何修复以下基数估计警告?
while exists(select 1 from @images)
begin
declare @imageid int
declare @filename varchar(max)
select TOP (1)
@imageid = [imageid],
@filename = concat([imageid], '.', [extension])
from
@images
order by
[imageid]
...
delete @images where [imageid] = @imageid
end
SQL Server 兼容级别:SQL Server 2019 (150)