方法一:
use AdventureWorks
select row_number() over(order by DatabaseLogID ) from DatabaseLog
except
select DatabaseLogID from DatabaseLog
方法二:
use AdventureWorks
select * from DatabaseLog order by DatabaseLogID
declare @i varchar(10),@r varchar(100)
set @i=1
set @r=''
while @i<(select max(DatabaseLogID) from DatabaseLog)
begin
if @i=(select DatabaseLogID from DatabaseLog where DatabaseLogID=@i)
begin
set @i=@i+1
end
else
begin
set @r=@r+@i+','
set @i=@i+1
end
end
print @r