每天删除多个表数据 [英] Delete multiple tables data on a daily basis

问题描述

hai，
我想要一个删除查询以每天删除多个表数据..即，数据将每24小时删除一次...

这些是我的sp

hai,
i want a delete query for deleting the multiple tables data on daily basis..i.e,the data will be delete every 24 hrs...

these are my sp''s

delete from Appointment Where UserId='5effd331-3fa4-4ef4-a358-40babc2890c8'

delete from Campaign where ProviderId='5effd331-3fa4-4ef4-a358-40babc2890c8'

delete from Contact where ProviderId='5effd331-3fa4-4ef4-a358-40babc2890c8'

delete from CompanyProduct where ProviderId='5effd331-3fa4-4ef4-a358-40babc2890c8'

delete from CompanyProvider where CreatedUserId='5effd331-3fa4-4ef4-a358-40babc2890c8'

请帮助我....

感谢和问候，
您的rk

please help me....

thanks and regards,
your''s rk

推荐答案

在sql中创建作业
参考网站，

http://www.petri.co.il/create-backup-job- in-sql-server.htm [ ^ ]

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

祝您编码愉快！
:)

Create Job In sql
Refer sites,

http://www.petri.co.il/create-backup-job-in-sql-server.htm[^]

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

Happy Coding!
:)

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