declare @name int,@strName varchar(50)
select @name=1
while @name<=156
begin
select @strName='M' + convert(varchar(50),@name)EXEC ('alter table TPM_进度 add ' + @strName + ' varchar(50)')select @name=@name+1
print @strName
end
select @name=1
while @name<=156
begin
select @strName='M' + convert(varchar(50),@name)EXEC ('alter table TPM_进度 add ' + @strName + ' varchar(50)')select @name=@name+1
print @strName
end
select @name=1
while @name<=156
begin
select @strName='M' + convert(varchar(50),@name)/*使用EXEC执行,否则不能使用参数*/
EXEC ('alter table TPM_进度 add ' + @strName + ' varchar(50)')select @name=@name+1
print @strName
end
select case index
……
end select
END SUB