判断一列是否连续,该如何解决

判断一列是否连续
数据库中有一列是NO，怎么样查询它的值是否连续
判断是否从1开始连续的 在线急等
把没有连续的显示出来

[解决办法]
http://topic.csdn.net/t/20040323/21/2877665.html
[解决办法]

SQL code

1,if(select max(no)-min(no)+1 from tb)=(select count(*) from tb)  print '连续'2,if(select max(no)-min(no)+1 from tb)=(select count(*) from tb) and select min(no) from tb)=1  print '从1开始连续'3,select number from master..spt_values  where type='p' and not exists(select 1 from tb where no=number) and number<(select MAX(no) from tb)