sqlintvarchar

① sql中int轉char的問題

declare @i int
declare @m varchar(2) --change to varchar(2)
set @i = 0
while @i < 96
begin
--set @m=convert(varchar,@i)
set @m=cast(@i as varchar)
print '消橋Face/'+@m+'.gif'叢橋數
set @i = @i + 1
end

--result
Face/滲首0.gif
Face/1.gif
Face/2.gif
Face/3.gif
Face/4.gif
Face/5.gif
Face/6.gif
Face/7.gif
Face/8.gif
Face/9.gif
Face/10.gif
Face/11.gif
Face/12.gif
Face/13.gif
Face/14.gif
...........