请问如何在Sql server 2005 查询分析器中循环建表,我写的不对,请指点,谢谢

显示全部楼层 · 2010-12-22 10:24:22

declare @i int, @j int, @z char(40)
set @i = 1
set @j=10
while @i<@j
begin
set @z='table' + rtrim(@i)
exce('create table ' + @z + '(
[A1] [varchar] (50) null,
[A2] [varchar] (50) null,
[A '+ @i+'] [decimal] (6,2) null
)
)
set @i = @i+1
end

千问 · 2010-12-22 10:24:22

declare @i int, @j int, @z char(40)set @i = 1set @j=10while @i<@jbeginset @z='table' + rtrim(@i)declare @sql varchar(1000)set @sql = 'create table '+@z+'([AA] varchar(50) null,[AB] varchar(50) null,[A'+ rtrim(@i)+'] decimal(6,2) null)'exec (@sql)set @i = @i+1end

千问 · 2010-12-22 10:24:22

declare @i int;declare @j int;declare @z char(40);set @i = 1set @j=10while @i<@jbeginset @z='table' + rtrim(@i)exce('create table ' + @z + '([A1] [varchar] (50) n