有什么方法可以用SQL生成当前年份的字母顺序

带有

ROW_NUMBER()

WITH cte AS (SELECt *, ROW_NUMBER() OVER (ORDER BY Record_Date) rn FROM LoadData)SELECt RIGHt(Current_Year, 2) +        CHAr(ASCIi('A') + rn / 26 + CASE rn % 26 WHEN 0 THEN -1 ELSE 0 END) +        CHAr(ASCIi('A') - 1 + CASE rn % 26 WHEN 0 THEN 26 ELSE rn % 26 END) Sequence_Code,       ID, Current_Year, Record_DateFROM cteORDER BY rn

如果要更新

Sequence_Code

WITH cte AS (SELECt *, ROW_NUMBER() OVER (ORDER BY Record_Date) rn FROM LoadData)UPDATE cteSET Sequence_Code = RIGHt(Current_Year, 2) +          CHAr(ASCIi('A') + rn / 26 + CASE rn % 26 WHEN 0 THEN -1 ELSE 0 END) +          CHAr(ASCIi('A') - 1 + CASE rn % 26 WHEN 0 THEN 26 ELSE rn % 26 END)

参见演示。
结果：

> Sequence_Code |     ID | Current_Year | Record_Date> :------------ | -----: | -----------: | :----------> 18AA          | 310001 |         2018 | 2018-01-01 > 19AB          | 310002 |         2019 | 2019-02-22 > 20AC          | 310004 |         2020 | 2020-02-10 > 20AD          | 310003 |         2020 | 2020-02-20