Sunday, 7 September 2014

To Identify Deleted Id in SQL Server

select number from master..spt_values s left join TableName b on s.number=b.Id
where s.type='p' and s.number<(select (MAX(Id)) from TableName) and b.Id is null

No comments:

Post a Comment