sql自动生成{00N}编号
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) =@nselect @bianhao as bianhao