sql存储过程

SQL code

ALTER procedure pro_InputExcel@TableNameTrim varchar(100)    ASif not exists ('select * from sysobjects where  id = object_id('+@TableNameTrim+')  and type in (u) ' )     'drop table ' + @TableNameTrimBEGIN    Declare @tableName As varchar(8000)    set @tableName = '['+rtrim(@TableNameTrim)+']'    EXEC(    'Create Table'+ @tableName+'     (    [id] int identity(1,1) not null primary key,    Name varchar(8000) default 0    )')END

这段代码有错误请高手帮忙改改

[解决办法]
请帖错误信息。
[解决办法]

探讨

请帖错误信息。

[解决办法]
错到家了。
= =
大哥
接字符串一定要用EXEC

if not exists ('select * from sysobjects where id = object_id('+@TableNameTrim+') and type in (u) ' )
'drop table ' + @TableNameTrim