Most voted "trigger" questions
A database server is a code of procedure executed automatically in response to certain events in a given table or view in a database.
Learn more…211 questions
Sort by count of
-
-1
votes1
answer39
viewsTrigger SQL Server
I have this Trigger in Postgresql and I’m having a hard time turning it into SQL Server. -- Trigger -- CREATE TRIGGER livro_original BEFORE INSERT ON tabela FOR EACH ROW EXECUTE PROCEDURE…
-
-1
votes1
answer97
viewsTRIGGER does not work in MYSQL
I’m trying to make a TRIGGER that inserts data into a table as soon as data is entered into another table. Original Table: CREATE TABLE tbGuia ( codigo_guia INT NOT NULL AUTO_INCREMENT,…
-
-1
votes1
answer36
viewsHow can I run a Rigger that automatically updates a table when an attribute is updated?
Create OR Replace TRIGGER filme_log before Update OF custo On filme Referencing New As New Old As Old For Each Row Begin Insert into filme_log Values(:new.nome_original, :old.custo, :new.custo,…
-
-1
votes1
answer46
viewsSQL-TRIGGER MAKING AUTO NUMBERING WRONG
Hello, I’m studying sql for very little time so I’m sorry if any nomenclature is not ok. I’ve created some triggers for my test database and in some cases it’s working perfectly. In others however…
-
-1
votes1
answer18
viewsProblem with update Trigger PLPGSQL
I have a Trigger for a stock audit, the Insert of it works, but the update no, or it changes nothing or changes all records with the same item code. How can I adjust this part of the Where of update…
postgresql function sql-update trigger plpgsqlasked 3 years, 6 months ago Camila Gabrielly Gonçalves 1 -
-1
votes1
answer30
viewsTrigger to devalue apartment price if garage linked to it is excluded
I need to create a Rigger that devalues the value of the apartment when a garage linked to it is deleted, I have the following tables: create table apartamento ( numero varchar(5) not null, tipo…
-
-2
votes1
answer77
viewsTrigger insert and change data
Good afternoon, I am trying to create a Trigger that after entering data(after Insert) in the table prodvdmat, it goes to the "input" table and checks if there is data in it, if there is no creates…
-
-2
votes1
answer31
viewsTrigger to check for data in another table
I’m trying to create a Trigger, using the following tables: The Trigger will be in the Table Carrier, and only need to check if in City.codcidade, there is some value equal to the…
-
-3
votes1
answer183
viewsJava Trigger Return
I have a Rigger that checks if the user login has more than 3 characters and if it does not have it returns the msg "login must have more than 3 characters", how can I capture this return in java…
-
-3
votes0
answers30
viewsSQL: I need my 2nd table with FK of the 1st automatically updated
I have a Sales_order table with Order Number and other information and created a table with FK of the 1st. I want every time a new order automatically falls in the 2nd (Requested) with the column…
-
-5
votes1
answer31
viewsTrigger for immovable system
Staff I am developing a property system and I need every five minutes the bank to read the property information, process and decrypt the information, send a processing confirmation and discard the…