Transact SQL Trigger
Kwitko
Sheriff of Banning (Retired)By the thing near the stuff Icrontian
I'm creating a update trigger in SQL Server 2000 that will monitor changes to our customer orders, but I'd like to monitor a specific change only.
I am trying to capture when the order status changes from either F, H, or R to X. Is it possible to do so with an UPDATE trigger, or do I have to capture all status changes?
I am trying to capture when the order status changes from either F, H, or R to X. Is it possible to do so with an UPDATE trigger, or do I have to capture all status changes?
0