尝试下面的代码
declare @a int =21Declare @sql varchar(max)='select *,'while @a <32beginset @sql = @sql + cast(@a as varchar) + ' as D' + cast(@a as varchar) + ' ,'set @a = @a+1endset @sql = substring(@sql,0,len(@sql)-1) + ' from tbl1' exec( @sql)
尝试下面的代码
declare @a int =21Declare @sql varchar(max)='select *,'while @a <32beginset @sql = @sql + cast(@a as varchar) + ' as D' + cast(@a as varchar) + ' ,'set @a = @a+1endset @sql = substring(@sql,0,len(@sql)-1) + ' from tbl1' exec( @sql)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
