34,590
社区成员
发帖
与我相关
我的任务
分享
select top 1 a.f+1 fempty
from tb a
left join tb b on a.f=b.f-1
where b.f is null
order by a.f
IF OBJECT_ID('dbo.Ta') IS NOT NULL
DROP TABLE dbo.Ta
Go
CREATE TABLE TA
(
ID INT NOT NULL
)
INSERT TA
SELECT 1 UNION
SELECT 3 UNION
SELECT 4 UNION
SELECT 6 UNION
SELECT 7
SELECT * FROM TA
SELECT
CASE
WHEN NOT EXISTS(SELECT * FROM dbo.Ta WHERE id = 1) THEN 1
ELSE (SELECT MIN(ID + 1)
FROM dbo.Ta AS A
WHERE NOT EXISTS
(SELECT *
FROM dbo.Ta AS B
WHERE B.ID = A.ID + 1))
END;