如何防止Sql Server表中多次进入前置数据修改？ [英] How to prevent multiple entry in table of Sql Server on prequent data modification ?

问题描述

我有一张桌子。我希望在每个键上插入最多三行。所以请告诉我如何防止它。因为正在进行非常快速的（mili second）条目。

I have one table. in which i want to insert maximum three row against each key. so please tell me how to prevent it. as there are very fast (mili second) entry is being done.

推荐答案

使用strop程序插入你的数据，例子

http://www.sqlinfo.net/sqlserver/sql_server_stored_procedure_INSERT.php [ ^ ]

http://www.mssqltips.com/sqlservertutorial/2519/insert-stored-procedure-in-sql-server/ [ ^ ]



在附带程序中确保检查，



如果数据计数> = 3为此关键抛出异常

否则让它插入



和trans行动不经意。

use strop procedure to insert your data, examples
http://www.sqlinfo.net/sqlserver/sql_server_stored_procedure_INSERT.php[^]
http://www.mssqltips.com/sqlservertutorial/2519/insert-stored-procedure-in-sql-server/[^]

In side procedure make sure you check,

If data count >= 3 for this key throw exception
else let it to be inserted

and the transaction obliviously.

这篇关于如何防止Sql Server表中多次进入前置数据修改？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！