去sqlserver中动态添加字段

drop table testcreate table test(	id int primary key identity(1,1),	name varchar(20));alter table test add clm_t1 nvarchar(20) nullalter table test drop column [[email protected]+']select * from test;declare @startYear int,@endYear int;declare @startMonth int,@endMonth intdeclare @dateStr nvarchar(20)declare @yearStr nvarchar(20)declare @monthStr nvarchar(20)set @startYear = 2000set @endYear=2011set @startMonth=1set @endMonth=12while(@startYear<[email protected])begin	while(@startMonth<[email protected])	begin		set @yearStr = convert(nvarchar,@startYear,4)		if(@startMonth<10)		begin			set @monthStr = '0'+convert(nvarchar,@startMonth,2)		end		else		begin			set @monthStr = convert(nvarchar,@startMonth,2)		end		set @dateStr = @yearStr [email protected]		print @dateStr		exec('alter table test add [[email protected]+'] nvarchar(50) null')		set @startMonth = @startMonth+1	end	set @startYear = @startYear+1	print convert(nvarchar,@startYear,4)end