Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««1234

Introduction to DML Triggers Expand / Collapse
Posted Thursday, November 13, 2008 7:58 PM



Group: General Forum Members
Last Login: Yesterday @ 9:30 PM
Points: 42,060, Visits: 39,443
timothyawiseman (11/13/2008)
Heh. Robert and Mohit have a point. Instead of triggers views could be used to let a legacy application interact with and change the data in the way it is designed to, while storing it in a completely separate fashion.

Still, those circumstances should be few and far between indeed. It is much better to change the application as well, and it is better still (in most cases) to put all updates and inserts through stored procedures and then the stored procedures can be changed to fit the data layer and the application will never be the wiser.

Heh... then, Robert and/or Mohit... please post an InsteadOf trigger that actually works, please! ;)

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #602488
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse