怎样新建一个以表名为参数的表

[hwsjtu]

CREATE PROCEDURE DBO.Create_Table
@name1 varchar(50)
AS
CREATE TABLE @name(
id integer ,
name varchar(30)
);
GO
以上是我写的存储过程
系统报错

[yujohny]

CREATE PROCEDURE DBO.Create_Table
@name varchar(50)
AS
declare @str nvarchar(200)
set @str='CREATE TABLE'+ @name+'(id integer ,name varchar(30))'
exec(@str)

[yujohny]

TABLE后漏了个空格，用下面的代码
CREATE PROCEDURE DBO.Create_Table
@name varchar(50)
AS
declare @str nvarchar(200)
set @str='CREATE TABLE '+ @name+'(id integer ,name varchar(30))'
exec(@str)

[yoki]

表名参数必须用动态语句
exec来执行

[zjcxc]

一是要用exec,二是不要写分号;

用下面的这个就行了:

CREATE PROCEDURE DBO.Create_Table
@name1 varchar(50)
AS
exec('CREATE TABLE '+@name+'(
id integer ,
name varchar(30)
)')
GO

[wzh1215]

CREATE PROCEDURE DBO.Create_Table
@name varchar(50)
AS
exec('CREATE TABLE '+@name+'(
id integer ,
name varchar(30)
)')
GO