Timeline for Data sanitation options on INSERT or UPDATE
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| 17 hours ago | comment | added | Charlieface |
IF TRIGGER_NESTLEVEL(OBJECT_ID(@@PROCID)) > 1 RETURN; should be reliable.
|
|
| 18 hours ago | comment | added | siggemannen |
I'd probably add that it's always good to do a check on @@ROWCOUNT > 0 before starting the trigger code, as well as only doing update when needed like: update t set x = trim(x) from sometable t where x <> trim(x) or datalength(x) <> datalength(trim(x))
|
|
| 23 hours ago | history | answered | Dale K | CC BY-SA 4.0 |