Select * from talbeName
Into #TestDemo
.......
If Exists (Select name From tempdb..sysobjects Where charindex('#TestDemo,name)>0 AND type = 'U') Drop Table #TestDemo
连续查询时临时表使用释放问题
最新推荐文章于 2022-08-02 05:00:30 发布
Select * from talbeName
Into #TestDemo
.......
If Exists (Select name From tempdb..sysobjects Where charindex('#TestDemo,name)>0 AND type = 'U') Drop Table #TestDemo