Cacher is the code snippet organizer for pro developers

PRINT REPLICATE('A--', 3) -- A--A--A--

-- 補零
DECLARE @C1 varchar(4) = '12';
PRINT DATALENGTH(@C1) -- 2
PRINT REPLICATE('0', 4 - DATALENGTH(@C1)) + @C1 -- 0012