Trigger Functions (Transact-SQL)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2012) ![no](media/no.png)Azure SQL Database ![no](media/no.png)Azure SQL Data Warehouse ![no](media/no.png)Parallel Data Warehouse

The following scalar functions can be used in the definition of a trigger to test for changes in data values or to return other data.

In This Section

COLUMNS_UPDATED

EVENTDATA

TRIGGER_NESTLEVEL

UPDATE()