简单写了一个手工输入凭证号，自动补号的SQL脚本

DECLARE @FNumber INT,@fstartnumber INT ;

SET @fstartnumber=900

SELECT ROW_NUMBER() OVER (ORDER BY FNumber)+@fstartnumber-1 AS FIndex, a.FNumber

INTO #tmp

FROM(SELECT FNumber

     FROM t_Voucher

     WHERE FYear=2020 AND FPeriod=7 AND FGroupID=1

     UNION

     SELECT FNumber

     FROM t_VoucherBlankOut

     WHERE FYear=2020 AND FPeriod=7 AND FGroupID=1) a WHERE a.FNumber>=@fstartn