sqlserver通用的删除服务器上的所有相同后缀的临时表
16lz
2022-01-14
复制代码 代码如下:
use tempdb
if object_id('tempdb..#table') is not null drop table tempdb..#table
select name into tempdb..#table
from (select * from sysobjects where xtype='U') a where
a.name like '%test_select'
declare @table varchar(100),@count int
select @count=count(name) from tempdb..#table
while(@count>0)
begin
select top 1 @table=name from tempdb..#table
exec('
if object_id('''+@table+''') is not null drop table '+@table+'
delete from tempdb..#table where name='''+@table+'''
')
set @count=@count-1
end
drop table tempdb..#table
建议:尽量不要大量使用临时表,因为使用tempdb库会使系统的负载加大。
use tempdb
if object_id('tempdb..#table') is not null drop table tempdb..#table
select name into tempdb..#table
from (select * from sysobjects where xtype='U') a where
a.name like '%test_select'
declare @table varchar(100),@count int
select @count=count(name) from tempdb..#table
while(@count>0)
begin
select top 1 @table=name from tempdb..#table
exec('
if object_id('''+@table+''') is not null drop table '+@table+'
delete from tempdb..#table where name='''+@table+'''
')
set @count=@count-1
end
drop table tempdb..#table
建议:尽量不要大量使用临时表,因为使用tempdb库会使系统的负载加大。
更多相关文章
- android读取assets大于1M文件的解决方法
- Android(安卓)加载服务器上的图片
- android studio设置launcher图标的问题
- android调用第三方软件打开下载的附件
- Android(安卓)加载服务器上的图片
- 在android 模拟器上安装 apt 文件
- 模拟器上安装Android(安卓)Market
- Logcat语法高亮显示:语法高亮显示为Android(安卓)Logcat文件
- adb install将app安装到eclipse Android(安卓)sdk 模拟器上看效