从sqlserver删除自动数据 [英] delete automaticaly data from sqlserver

问题描述

id如何在sqlserver中自动删除表中的许多行
例如，每1个月
我想在没有登录的情况下执行此操作.

how id do delete automatically many row of a table in sqlserver
example every 1 month
i want do this without login

推荐答案

使用SQL Server批处理或任务计划.查看下面的MSDN链接:

http://msdn.microsoft.com/en-us/library/ms191439 (v = sql.105).aspx [ http://msdn.microsoft.com/en-us/library/ms189267 (v = sql.105).aspx [

Use SQL Server Batch or Task Scheduling. Look at MSDN links below:

http://msdn.microsoft.com/en-us/library/ms191439(v=sql.105).aspx[^]

http://msdn.microsoft.com/en-us/library/ms189267(v=sql.105).aspx[^]

创建一个JOB (in SQL Server Agent).创建NEW JOB的步骤很简单.

create a JOB (in SQL Server Agent). For creating a NEW JOB there are simple steps.

1. General<br />
2. Steps<br />
3. Schedule<br />
4. Alerts<br />
5. Notification<br />
6. Target

在上述步骤中，您必须填写相应的字段.然后您可以执行QUERIES 或SCHEDULES.等


谢谢
灰烬

In these above steps you have to fill the respective fields. and then you can execute QUERIES or SCHEDULES. etc.


Thanks
Ashish

这篇关于从sqlserver删除自动数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！