返回最小的缺失值 MS SQL2000

DECLARE @T TABLE (ids INT)
 
 INSERT INTO @T
 SELECT 1 UNION
 SELECT 2 UNION
 SELECT 3 UNION
 SELECT 4 UNION
 SELECT 6 UNION
 SELECT 7 UNION
 SELECT 8
 
 SELECT 
  (CASE WHEN MIN(ids) - 1 = 0 THEN  MAX(ids) - 1 ELSE MIN(ids) - (MIN(ids) - 1) END)

 FROM @T T1 WHERE NOT EXISTS (SELECT 1 FROM @T T2 WHERE T2.ids +1 = T1.ids)

 

2011-06-25