-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
we have application where database contains large parts of business logic in triggers, with a update subsequently firing triggers on several other tables. I want to refactor the mess and wanted to start by extracting procedures from triggers, but can't find any reliable tool to do this. Using…
>>> More
-
as seen on Programmers
- Search for 'Programmers'
When I was originally learning about SQL I was always told, only use triggers if you really need to and opt to use stored procedures instead if possible.
Now unfortunately at the time (a good few years ago) I wasn't as curious and caring about fundamentals as I am now so never did ask to the reason…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am trying to use an update trigger in sql 2000 so that when an update occurs, I insert a row into a history table, so I retain all history on a table:
CREATE Trigger trUpdate_MyTable ON MyTable
FOR UPDATE
AS
INSERT INTO
[MyTableHistory]
(
[AuditType]
,[MyTable_ID]
…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi All,
Is it possible to use .net (C# SQL CLR) to find all the triggers associated with a table?
And also will I be able to determine the type of that trigger? - CLR or T-SQL?
Thanks,
Chaks
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
how can I list out all triggers on a table?
>>> More