if update sql

Solutions on MaxInterview for if update sql by the best coders in the world

Search
showing results for - "if update sql"
Luca
17 Aug 2017
1-- SQL Server (update my_table after update on my_table)
2CREATE TRIGGER trTest ON my_table AFTER UPDATE AS
3IF UPDATE (col_name)	-- Optional, for particular column
4BEGIN
5    UPDATE my_table SET my_col_date = getdate() FROM my_table 
6END
7-- Oracle (insert into log table after update on my_table)
8CREATE OR REPLACE TRIGGER trTest AFTER UPDATE ON my_table
9FOR EACH ROW
10BEGIN
11    INSERT INTO my_log_table (LOG_DATE, ACTION) VALUES (SYSDATE, 'Changed');
12END;
source
similar questions
updating values in sqlsql update with statementupdate sql sintaxhow to update date value in sqlsql server if exists update else insertsql update recordsql update klauselhow to update values in sqlupdate sqlupdate in sqlsql updatesql updatehow to update data in sqlhow to update row in sqlsql update queryupdate values in select statement sqlupdate select sqlupdate command in sql
queries leading to this page
update if sql querysql server update trigger row specificupdate sql with if conditionupdate if else sqlsql update if conditionafter update sql trigger new old valueupdate table if condition sqlupdate if sqlif statement in update sqlcondition in update sqlsql update if existssql server trigger for each row updatedupdate if exist sqlsql if updateif statement with update in sqlsql server trigger after update specific column valueif statement in sql updateupdate if set sqlsql server trigger update get new valuesql update if elsesql if statement updateif else in sql update tableif update sqlsql trigger after update get old valuesql update if existupdate if condition sqlsql update ifupdate com if sqlsql server trigger after update old value new valueif in update statement sqlelse if statement in update sqlsql server update trigger get old and new valuesql server update query with if conditionsql server trigger after update get old valueif exist sql then updateif update sql