SQL语句查询表中缺失自增键

SELECT  RecordId + 1
FROM    dbo.RedeployPackageRecord RPR ( NOLOCK )
WHERE   NOT EXISTS ( SELECT 1
                     FROM   dbo.RedeployPackageRecord RPR2 ( NOLOCK )
                     WHERE  RPR.RecordId + 1 = rpr2.RecordId )
                    

posted on 2011-07-08 12:28  mxxiao  阅读(378)  评论(0编辑  收藏  举报

导航