数値型の値の中から、最大の空き番号を取得します。
SELECT ID FROM CUSTOMER
SELECT ID
FROM CUSTOMER
SELECT MAX(ID) + 1 AS [BLANKID] FROM CUSTOMER
SELECT MAX(ID) + 1
AS [BLANKID]