Skip to content
Advertisement

SQL Server trigger on specific column updated

I have a table with the following columns: ID | CLIENT_SYNCED_TIME | NAME | DESCRIPTION | LM_TIME The LM_TIME column will be set automatically by a trigger when any of the other column values get …

SQL Case insensitive IN search

I have this Table “Table” with content: +——–+ | Serial | +——–+ | d100m | <- expected result | D100M | <- expected result | d200m | <- expected result | d300L | | D400R | +—–…

Record “old” not assigned yet

I have created this trigger: CREATE TRIGGER trig_update AFTER INSERT ON “delivery” FOR EACH ROW EXECUTE PROCEDURE premium1(); With this function: CREATE OR REPLACE FUNCTION premium1() RETURNS …

Advertisement