看壹看。
declare @num int,@strnum nvarchar(20)
set @num = 0
開始
while @ num & lt10
set @ strnum = cast(@ num as varchar(10))+':'+cast(@ num as varchar(10))
print @strnum
set @num=@num+1
結束