SqlServer根据日期动态建表，动态删表

建表

declare @name varchar(50)
declare @sql varchar(1000)
set @name ='AlarmCountConfig_'+convert(varchar(23), getdate(),112);
set @sql = 'select top 0 * into '+@name+' from AlarmCountConfig';
print @sql
exec(@sql)

删表

declare @Count int 
declare @LastTableName varchar(100)
declare @Sql varchar(1000)
set @Count=100


set  @LastTableName='2018-10-30'

while @Count>0
begin
set @Sql='drop table tb_AccessLayerTraffic_'+
CONVERT(varchar,DATEADD(day,-@Count,@LastTableName),112)

exec (@Sql)
set @Count=@Count-1
end

可配合存储过程和作业来定期执行，实现表的动态生成和过期数据的动态清理