Top "Triggers" questions

How to add "IF NOT EXISTS" to create trigger statement

I am using sql server 2008 R2. More specifically, Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation …

sql sql-server tsql if-statement triggers

IF UPDATE() in SQL server trigger

If there's: IF UPDATE (col1) ...in the SQL server trigger on a table, does it return true only if col1 …

sql sql-server sql-server-2005 triggers

How to Generate Scripts For All Triggers in Database Using Microsoft SQL Server Management Studio

I'd like to generate an SQL Script that contains the SQL to create all of the triggers that exist in …

sql sql-server-2008 triggers

Difference between FOR and AFTER triggers?

What's the difference between FOR and AFTER triggers?

sql sql-server-2005 triggers

Android Spinner - onItemSelected / setOnItemSelectedListener not triggering

This is driving me nuts since it's something I've done before but can't figure out why it isn't working now... …

android android-layout triggers spinner listener

How to create a before delete trigger in SQL Server?

I want to create a before delete trigger. When I delete a record from a table that record has to …

sql-server triggers

Get first date of month in postgres

I'm trying to get a 'date' type that corresponds to the first day of the current month. Basically one of …

postgresql date triggers

ERROR: unterminated quoted string at or near

While executing below shown trigger code using ANT I am getting the error org.postgresql.util.PSQLException: ERROR: unterminated quoted …

postgresql ant triggers plpgsql

How to use update trigger to update another table?

I am new to triggers and want to create a trigger on an update of a column and update another …

sql sql-server-2008 triggers sql-update

What is the most portable way to check whether a trigger exists in SQL Server?

I'm looking for the most portable method to check for existence of a trigger in MS SQL Server. It needs …

sql-server triggers information-schema