Tech Boys Group Dance

iframe width 459 height 344 src //www.youtube.com/embed/YPwqnfRUfxM frameborder 0 allowfullscreen> /iframe>

How to find missing sequence number in a column of sql table?

Answer:-

UPDATE a

SET a.seq = b.seq+1FROM table1 AS a(NOLOCK)INNER

JOIN table1

AS b(NOLOCK)LEFT

OUTER JOIN table1 AS c(NOLOCK)ON b.seq + 1 = c.seqON a.seq-1 = a.seq+1WHERE b.seq IS NULL