Triggers look like a simple audit logging solution. Why should I use interceptors?
what others?
Another minor issue is that triggers do any DML. nHibernate uses counted lines to determine success in many of its operations. If you do any insertions / updates / etc. inside your triggers, then you need to enable NOCOUNT inside the triggers to prevent false lines from appearing.
, , , . EventListeners - , .
, icky T-SQL...
Con -, , , . , , (, - 10%). , , . sql , , , , . , , , . , , evreything , , , . , , SSIS ( DTS) , , . , , , GUI .
, :
. .
. .. , , .
. , , , HLGEM . senario.
HLGEM. , , : :
, . -, .
, - . . , , , , (.. ).
Source: https://habr.com/ru/post/1703766/More articles:What is the best way to create an identifier for SQL insert? - sqljQuery UI Draggable - need to modify an element when dragging and dropping - javascriptHow .NET Framework Versions Support Backward Compatibility - .netПоследствия для условий sql 'OR', когда одна альтернатива тривиальна? - optimizationWhat is called this algorithm? - algorithmhttps://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1703767/piecemeal-conversion-from-struts-to-tapestry-5&usg=ALkJrhj5PDXbkMscO75nAUVWcoDGT0JixAScrolling table using jQuery - jqueryHow can I intercept and correct low-level keystrokes? - macrosHashmap efficiency for stdxt C ++ - reorganization (?) - c ++PHP: Detect "undefined function" errors before running? - phpAll Articles