how to find string match in any updated columns in a trigger
Database
2
Posts
2
Posters
1
Views
1
Watching
-
Hi Good Guys! I want to write a trigger which can iterate through each udpated column and check for a string match. if found then I need to rollback. TIA
-
Hi Good Guys! I want to write a trigger which can iterate through each udpated column and check for a string match. if found then I need to rollback. TIA
You can use COLUMNS_UPDATED (Transact-SQL) and Update() function to find out information about updated columns.
Giorgi Dalakishvili #region signature my articles #endregion