declare
@TableName varchar(20), --数据表名
@Sql varchar(100), --SQL语句
@Year int, --年份
@Month int --月份
set @year=Year(getDate())
set @Month=Month(getDate())
set @TableName = 'finance'+cast(@Year as varchar)+'_'+cast(@Month as varchar)
--如果该表已经存在,那么删除该表
if exists(select name from sysobjects where xtype='u' and name=@tableName)
drop table [@TableName]
--将财务数据导入备份表
EXEC('select * into '+@tableName+' from finance')
------
@TableName varchar(20), --数据表名
@Sql varchar(100), --SQL语句
@Year int, --年份
@Month int --月份
set @year=Year(getDate())
set @Month=Month(getDate())
set @TableName = 'finance'+cast(@Year as varchar)+'_'+cast(@Month as varchar)
--如果该表已经存在,那么删除该表
if exists(select name from sysobjects where xtype='u' and name=@tableName)
drop table [@TableName]
--将财务数据导入备份表
EXEC('select * into '+@tableName+' from finance')
------
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货