我想每天清除sqlserver表中的所有数据 [英] I want clear all the datas in sqlserver table every day

问题描述

我正在做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中创建计划作业，该计划作业会在任何持续时间触发.
请参考以下链接:

http://msdn.microsoft.com/en-us/library/ms191439.aspx [ ^ ]

You Can create Schedule Job In Sql Server which fire on anytime duration.

refer to following link:

http://msdn.microsoft.com/en-us/library/ms191439.aspx[^]

这篇关于我想每天清除sqlserver表中的所有数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！