triggers
SQL Stored Procedures To Run Automatically
I have an asp.NET framework 4 web form website with user login capabilities etc etc... Im using visual studio 2010.[详细]
2023-04-06 20:41 分类:问答SQL Trigger deleting from multiple tables
I have 2 tables with relation in between. table one is holding groups with groupid. table 2 is holding the relation between the 2 groups.[详细]
2023-04-06 20:35 分类:问答Can I create an event in a trigger?
Is it possible to create a new event from inside a trigger? It\'s not something I\'d particularly recomment, but I\'m just wondering if it can be done.[详细]
2023-04-06 19:51 分类:问答Can I create a trigger that involves a cursor on a table that the trigger is not made for?
For example if I have a trigger for table employee. I want to create a cursor loop from thetable department. Then I want to take the attribute and insert it into the table company. I\'m guessing the a[详细]
2023-04-06 18:57 分类:问答How did my SQL Server 2008 trigger get deleted?
This is a very strange problem. I\'ve asked about it before here: How did my trigger get deleted? I renamed my trigger and I thought it had stopped happening but the problem seems to have come back ag[详细]
2023-04-06 18:56 分类:问答Create a trigger with a stored procedure in MySQL
Is it possible to build a stored procedure that creates a trigger in MySQL? I have the stored proc below, which works fine, but it only outputs the code to create the trigger, but does not actually cr[详细]
2023-04-06 16:39 分类:问答Quartz .Net Job should reschedule itself
I\'m using a Quartz .NET job to get data from serial port periodically. The problem is that if the serial port is used by a another programm the job should reschedule itself to maybe try it in 30min a[详细]
2023-04-06 15:08 分类:问答Please help move WPF trigger behavior to Silverlight
The WPF code: <TextBox> <TextBox.Resources> <Style TargetType=\"TextBox\"> <Style.Triggers>[详细]
2023-04-06 12:20 分类:问答autonomous_transaction in trigger and constraint violation
I\'ve encountered an interesting situation experimenting with the autonomous_transaction. Consider the following situation (please note it\'s is not intended to be written this way: just proof of conc[详细]
2023-04-06 08:36 分类:问答Triggers versus Views: which provides better (row) version control?
We are using \"versioned\" columns in our order processing system. +----------------------------+ ID | VERSION|[详细]
2023-04-06 08:15 分类:问答