SQL – How to Find Missing Sequence in a table

Problem statement:- A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?Solution:-create table MissingRowDemo (a int); insert into MissingRowDemo values (7001); insert into MissingRowDemo values (7002); insert into Miss

SQLQuery42.sql
 
 
 
 
 
(0)
346 times
Add to favorites
Databases
12/23/2014
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


Be the first to ask a question.