SQL 生成流水号(自动补零)

--年份+流水号: 20200001
DECLARE @code INT=123,@year VARCHAR(50)=CAST(YEAR(GETDATE()) AS VARCHAR(50))
--SELECT @year
--SELECT RIGHT('0000'+CAST(@code AS VARCHAR(50)),4)
--SELECT @year+ RIGHT('0000'+CAST(@code AS VARCHAR(50)),4)
--SELECT @year+ CAST(@code AS VARCHAR(50))

SELECT @year + (CASE WHEN LEN(@code)<4 THEN RIGHT('0000'+CAST(@code AS VARCHAR(50)),4) ELSE CAST(@code AS VARCHAR(50)) END)