不知道表名如何定义
我用create table bbs '[email protected]+ '好象不行(刚开始学的,可能笑话了)
代码如下:
declare @i int
set @i=3
while @i <5
begin
create table bbs '[email protected]+ '
(
id int,
title varchar(100),
Content varchar(8000)
)
create table report '[email protected]+ '
(
id int,
topid int,
Content varchar(8000),
ip varchar(15),
)
set @[email protected]+1
end
------解决方案--------------------
declare @i int
declare @sql nvarchar(200)
set @i=3
while @i <5
begin
set @sql= 'create table bbs '+CONVERT(nvarchar(20),@i)+ '
(
id int,
title varchar(100),
Content varchar(8000)
)
create table report '+CONVERT(nvarchar(20),@i)+ '
(
id int,
topid int,
Content varchar(8000),
ip varchar(15),
) '
exec (@sql)
set @[email protected]+1
end