SELECT power(10,4)
SELECT cast(power(10,4) as VARCHAR) --10000
SELECT cast(power(10,4) as VARCHAR)+1 --100001
select right(cast(power(10,4) as varchar)+1,4)
SELECT power(10,4)
SELECT cast(power(10,4) as VARCHAR) --10000
SELECT cast(power(10,4) as VARCHAR)+1 --100001
select right(cast(power(10,4) as varchar)+1,4)