declare @str varchar(200) set @str='' -- 必须先赋值 select @str= @str+ cast(bb as varchar(30)) from #tb print @str