sql数据库一个表定时改名字并创建一个新表答:declare @tbName varchar(100),@sql varchar(2000),@date datetime select @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(@...