SQL Server has the ability to provide the information on  specific columns which  been modified by triggers, by using the COLUMNS_UPDATED function. COLUMNS_UPDATED is an in-built function of SQL server that helps to identify the columns in the table or view that were inserted or updated. COLUMNS_UPDATED returns a varbinary bit pattern showing which columns [...]