SQL Server Common temporary table to delete all the same suffixes on the server _mssql

Copy Code code as follows:

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 (m), @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

Recommendation: Try not to use temporary tables as much as possible, because using the tempdb library will increase the load on the system.