DECLARE @n VARCHAR(50) =RIGHT('0000000'+LTRIM(cast( CONVERT(int, isnull((SELECT MAX(bianhao) FROM Table),0))+1 as VARCHAR(15))),3);
DECLARE @bianhao VARCHAR(50) =@n
select @bianhao as bianhao
sql自动生成{00N}编号
最新推荐文章于 2023-01-05 18:18:00 发布
DECLARE @n VARCHAR(50) =RIGHT('0000000'+LTRIM(cast( CONVERT(int, isnull((SELECT MAX(bianhao) FROM Table),0))+1 as VARCHAR(15))),3);
DECLARE @bianhao VARCHAR(50) =@n
select @bianhao as bianhao