ALTER procedure pro_InputExcel

@TableNameTrim varchar(100)    

AS

if not exists ('select * from sysobjects where  id = object_id('+@TableNameTrim+')  and type in (u) ' )
     'drop table ' + @TableNameTrim
BEGIN
    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