我坐在一个永远不应残疾的桌子上。 该局进行某些检查,有时其他开发商会使其失去能力。 这不是好事,因此,我只想放弃本表上的触发争端。 这是可能的吗? 如果没有,请提出任何建议。 感谢。
WORKAROUND: Seems from peeps responses that it s not possible to prevent it. Maybe getting an alert would be suitable. This is a good article, shame it doesn t work with EventData though. Maybe in 2008, this is resolved: http://www.simple-talk.com/sql/database-administration/dml-trigger-status-alerts/
No. Disabling is an admin operation and as such can not be prevent. 您可以检查触发器是否按照法律残疾,但不能防止残疾。
即便是开发商(在进行脱).时)也有意义。
你没有技术问题,你有社会问题。
这些“其他开发商”是谁?
他们为什么调整触发点?
其宗旨是什么?
触发因素有什么错误?
你应该与他们交谈,了解他们的问题。
寻找只会使问题恶化或更加复杂的技术“解决办法”的浪费时间。 赋予人民。 与他们会谈。
唯一的解决办法是:
开发商不应拥有生产数据库的行政权。 他们不应有可分割的触发点,因为他们不应有权利在选择之外做任何事情。
人们感到需要加以消除的触发因素是什么问题? 它写得不好? 它没有正确处理多行? 它是否防止发生需要发生的事情?
在这种情况下,我们有文件说明如何处理绕过触发点,而不是拆解触发点(即设定国旗),但显然某些开发商知道情况较好。
这表明,触发因素本身是一个问题。 这样做不需要工作。
根据评论
在你的数据中添加一个超负荷的触发点。 当你想要推翻该议程时,如果插入的表格具有价值1,那么,如果存在某种障碍,无视触发因素中你需要忽略的部分内容,但这种情况会继续下去,而且会引发其他行动。 最终,压倒一切的领域的价值被否定。
或者,将审计触发点放在单独的触发点上,这样,当审计触发点不能满足其临时需要时,审计触发点仍然运行。
或者把“有时我们管理起来”完全放在触发点之外,并把它添加到你想要管理而不是他人的记录的过程中。
我倾向于同意同性恋、双性恋和变性者的观点。 你们也许会做错事,使人感到需要绕过它。 因此,它就被排除或改写。 我说“可能是”的,因为几乎所有的触发因素都没有必要,而触发因素通常是制定数据操纵代码的不良地点。 在不修改数据的情况下执行商业规则的捷径足够合理。 确实做过普遍定期审议、INSERTs和DELETE的三角关系一般比其价值要大得多,几乎总是可以用更好的替代办法来取代。
Maybe You can create another user, grant select/insert/update/delete on additional tables to new user. Or, You can revoke access to triggers to your user, which owns tables.
尽可能利用制约因素,确保它们得到信任。
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...
