问题描述
我正在使用Web应用程序。在我的数据库中，我想基于此更新自动更新。我正在创建库管理员。预订可供选择。如果有人不来这本书得到很长一段时间。状态表自动更改为取消。此外，邮件有时也会自动发送给特定的学生。在这种情况下，即使应用程序未运行，也必须自动执行该过程。哪一个是该案例的最佳解决方案。触发器还是其他什么？
在此先感谢..
I m working with web application. In my database, I want to update automatically updated based on that. I m creating library managent. There are an option for book reservation. If somebody not come for get the book long period. The table of the status is automatically changed to ''cancel''. And also a mail is automatically send to particualar students sometimes. In that case even the application is not running that process are automatically should have to be done. Which one is best solutions for that case. Triggers or anything else?
Thanks in advance..
推荐答案
这篇关于如何自动更新sqlserver中的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！