declare @tbName varchar(100),@sql varchar(2000),@date datetimeselect @tbName = convert(varchar(10),getdate(),120)select @tbName = substring(@tbName,1,4)+substring(@tbName,6,2)+substring(@tbName,9,2)select @sql='select * into syslogd_'+@tbName+' from syslogd'exec(@sql)truncate table syslogd select @date=dateadd(month,-3,getdate())
declare cur cursor for select name from sysobjects where crdate<@date and xtype='U' and name like 'syslogd_'open curfetch next from cur into @tbNamewhile @@fetch_status=0begin
select @sql='drop table '+@tbName
exec(@sql)
fetch next from cur into @tbNameendclose curdeallocate cur 经过测试的,可以用了
|