mysql> desc test; +-------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | a | int(10) unsigned | NO | | NUL...
Hi, I want to check if all the triggers are on or not on the SQL Db I am working on. How can I achieve that? Thanks, ...
I am looking at the possibility for an AutoCheck style jQuery HTML application that every 5 second it goes off the a DB and checks some data. That is the easy part, which I can do. Now what I would like is to have an AutoCheck time going, something like var t = setTimeout("autocheck()", 5000); So every 5 seconds it is triggered, and...
Is it possible to write cron expression for trigger that must fire every day and every minute from 12:04 to 14:25? ...
Hiya, Long time reader, first time caller, and all that... Here's the business problem: a user makes one or more requests for documents. At some later time, a document is uploaded to the system. If that document matches one or more of the requests, the document request is fulfilled. So, there could be one or many requests for Document ...
Running this procedure causes MySQL (or phpMyAdmin) to freeze. I have to stop MySQL with from XAMPP command, which freezes and "is not responding" about 20 seconds before stopping. I believe this is caused by the delimiter command, which on it's own begins the problems. I have tried using a different delimiter ("//") to no effect. Any h...
I have a table called "teams" with column "inactive" and another table "events" with column "time". How can I have the "inactive" column updated (to true), if the latest date in "events" for any team occurred X amount of time ago? I know this can be doe with a php script, but i'm looking for a sql solution ...
Hi Is there any way to implement a time based trigger in Mysql 5.1 i.e. it must run at 12H05 every day Edit A corn job calling an SQL script is currently been used - but I am looking for a less complicated solution. ...
Hello all, I want to do some calculations when my table data is changed. However, I am updating my table manually and copy pasting about 3000 rows in once. That makes my trigger work 3000 times, but I want it to do the trigger only once. Is there a way to do that ? Thanks. ...
I have the below SQL Trigger on a SQL 2005 box that is supposed to help me replicate certain Person Info to another database to be used for Reporting and various other things as a reference. I have 1 DB named Connect which is where the current app manipulates the Person Data on tblPerson. I have another DB, on same physical box, named ...
To eliminate the potential problems with triggers, what are some of the alternatives one may use to get the same functionality of reacting to an event fired on a INSERT action? I have a database that needs to have some additional values added on insert. The INSERT is controlled by compiled code and cannot be changed. EXAMPLE: The progr...
Hi all, I want to create a table trigger for insert and update. How can I get the values of the current record that is inserted/updated? ...
are there any time based triggers in DB2? ...
I have created an INSTEAD OF INSERT trigger on a view in my database. I want to know which columns are included in the column list of the INSERT statement on the view. If you read the MSDN documentation for triggers the UPDATE() and COLUMNS_UPDATED() functions should satisfy this requirement. However, during my testing I found that re...
When it comes to denormalizing data in a transactional database for performance, there are (at least) three different approaches: Push updates through stored procedures which update both the normalized transactional data and the denormalized reporting/analysis data; Implement triggers on the transactional tables that update the seconda...
Hello Friends, I have some troubles trying to move data from SQL Server 2000 (SP4) to Oracle10g, so the link is ready and working, now my issue is how to move detailed data, my case is the following: Table A is Master Table B is Detail Both relationed for work with the trigger (FOR INSERT) So My query needs to query both for create a ...
I'm trying to set up a MySQL trigger, but I can't figure out how exactly to get what I want done. I think I need to set up a MySQL @variable but what I've tried hasn't worked and I have not been able to find a good resource figure it out. I change the delimiter in phpMyAdmin, and the comment in the below is not used in the actual query. ...
Is there any way to create trigger using OCI API? I need to perform the following actions programmatically: CREATE OR REPLACE TRIGGER tbl_trigger BEFORE INSERT ON tbl FOR EACH ROW WHEN (new.id IS NULL OR new.id = 0) BEGIN SELECT tbl_sq.nextval INTO :new.id FROM dual; END; / ...
I have a set of triggers in a XAML form, and for the life of me I can't figure out why one set works, and the other doesn't, despite being bound to the exact same variable. First, the triggers that do work: <StackPanel Orientation="Vertical" Margin="25,0,0,0"> <StackPanel.Style> <Style TargetType="{x:Type StackPanel}"> ...
Hi there, I have this table that represents a weak entity and is a typical table for introducing items ordered: insert into ITEM_FORNECIMENTO values (a_orderId,a_prodId,a_prodQtd, a_buyPrice); I want my trigger to update the last column (the total price of products WITHOUT iva) to do this : totalPrice= totalPrice*(1+(iva/100), each t...