急:用存储过程建表的问题,在线
--split data related with our company
CREATE PROCEDURE split_data
@BeginDate DATETIME,
AS
DECLARE @TableName VARCHAR(20)
SET @TableName=YEAR(@BeginDate)+'split_results'
IF NOT EXISTS ( SELECT * FROM sysobjects
WHERE id = object_id(N'[dbo].['+@TableName+']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE @TableName(
date_time datetime not null,
ownerstation int not null,
)
就是要建一个表,表的名字是由传入的参数决定的
但我用了@TableName,后面的create table 报错,请指点!