SQL中循环语句的效果实例
复制declare @sSql varchar(8000) select @sSql = select @sSql = @sSql + alter table #tt add A + rtrim(convert(varchar(20),循环 GroupID)) + decimal(5, 1) + CHAR(10) from HRS_Group where Type = 0 order by GroupID select @sSql 1.2.3.4.5.
复制declare @sSql varchar(8000) select @sSql = select @sSql = @sSql + alter table #tt add A + rtrim(convert(varchar(20),循环 GroupID)) + decimal(5, 1) + CHAR(10) from HRS_Group where Type = 0 order by GroupID select @sSql 1.2.3.4.5.