我想每天清除sqlserver表中的所有数据

本文介绍了我想每天清除sqlserver表中的所有数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在做Restarunt项目.我有桌子Tempbill，计费帐单.每天Tempbill和Bill记录表都会刷新.所以我要在下午24.00之后将上述表记录复制到Excel工作表中.表格将被清除.因此，第二天是Billno以No:1开始.怎么做.如何将一个表的所有记录复制到excel工作表. 请帮助我

I am doing Restarunt Project. I have tables Tempbill,Bill for Billing. Every day the table Tempbill and Bill records are freshup. So I want after 24.00 pm the above table records copy to excel sheet. And the tables will be cleared. So the next day is Billno is start up with No:1. How to do it. How to copy all the records of the one table to excel sheet. Please help me

推荐答案

您可以在Sql Server中创建计划作业，该计划作业会在任何持续时间触发. 请参考以下链接: msdn.microsoft/en-us/library/ms191439.aspx [ ^ ] You Can create Schedule Job In Sql Server which fire on anytime duration. refer to following link: msdn.microsoft/en-us/library/ms191439.aspx[^]