SELECT RecordId + 1
FROM dbo.RedeployPackageRecord RPR ( NOLOCK )
WHERE NOT EXISTS ( SELECT 1
FROM dbo.RedeployPackageRecord RPR2 ( NOLOCK )
WHERE RPR.RecordId + 1 = rpr2.RecordId )
转载于:https://www.cnblogs.com/mxxiao/archive/2011/07/08/2100859.html