create view dest_temp as select * from dest_01 where day=@day
变量@day是昨天的日期
然后
bcp 出该视图dest_temp为昨天的数据
然后删除该视图
drop view dest_temp
把以上语句作为sql批处理,在服务器中做crontab定时调用,每天都自动存储昨天的数据。
可就是create view dest_temp as select * from dest_01 where day=@day时出现以下错误:
Remapping utility - Wrong kind of node passed to tree remapping. This is an internal system error.