如何在系统故障时删除临时表数据 [英] How to delete Temp table data in system failure

问题描述

我正在创建Win Form应用程序，并且我有一个用于用户会话的临时表.提交信息后，将执行删除"查询.
现在，我要问的是如何在系统重新启动或系统故障时删除此临时信息.

I am creating win form application and i have a temp table for a user session. after submitting information ''Delete'' query executes.
Now my ques is how to delete this temp information in system restarts or in a system failure.

推荐答案

系统故障是无法预测和不可控制的，并且您有足够的时间(如果有)清理.

最好的选择是在用户首次登录时清除临时数据.

System failures are unpredictable and unconontrollable, and you bearly enough time if any to cleanup.

Your best option is to clear the temp data on first login of the user.

http ://www.sqlteam.com/article/temporary-tables [ ^ ]

实际上有1个以上的用户正在使用相同的登录凭据.如果删除查询在登录后执行，则其他用户的数据也会丢失.

actually more than 1 user are using same login credentials. If delete query executes after login then other user''s data also b lost.

这篇关于如何在系统故障时删除临时表数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！