SQLSERVER动态删除数据库的表

IF object_id('tempdb..#tempTB') IS NOT NULL
BEGIN
DROP TABLE #tempTB
END

CREATE TABLE #tempTB(
 sql_drop nvarchar(MAX)
)

declare @tempSQL nvarchar(MAX);

declare @SQL_DROP nvarchar(MAX)='';
DECLARE @SCV_SERVER nvarchar(MAX)='[DATABASENANE]';
set @tempSQL = 'insert into #tempTB (sql_drop) select　*from TABLENAME';
exec(@tempSQL);
select * from #tempTB;

--动态查询临时表行数，并赋值到变量
declare @tempCon int;
set @tempSQL = N'select @tempCon = count(*) from #tempTB;';
exec sp_executesql @tempSQL,N'@tempCon int output',@tempCon output;
select @tempCon;

select @SQL_DROP=@SQL_DROP + sql_drop from #tempTB

print　@SQL_DROP

DROP TABLE #tempTB