.Net , SQL & React
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment