摘要： 表Luck 是存放已被使用的数字CREATE TABLE [Luck]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Key] [bigint] NULL,)插入几条数据Insert Into Luck(Key) Values(1)Insert Into Luck(Key) Values(2)Insert Into Luck(Key) Values(3)Insert Into Luck(Key) Values(5)查询 1-10且不存在 Luck中 借助master.dbo.spt_valuesselect top 1 number from master.d 阅读全文