drop table #temp create table #temp (ch char(1)) go --if object_Id(@tablename) is not null declare @tablename varchar(10) declare @execS varchar(max) set @tablename = '#temp' if object_id('N''#temp') is not null -- Doesn't work begin print 'Try to delete' set @execS = 'drop table ' + @tablename exec sp_executesql @execS end>Ok, I don't understand what's wrong here:
>drop table #temp >declare @tablename varchar(10) > >create table #temp (ch char(1)) >set @tablename = '#temp' > >if object_Id(@tablename) is not null > exec ('drop table ' + @tablename) >>
>DECLARE @sTableName varchar(max) > >SET @sTableName = '#temp' > >if object_Id(@sTableName) is not null > exec ('drop table ' + @sTableName) > >SELECT t.iTrade_Id > INTO #temp > FROM Trade t > >>