Hi all !
I necessary of triger to make one update of a primary key (I know that it is not a common procedure, but is because already I caught the bank of this form) use the SQL Server 7.0 Catching as example the bank pubs that it comes in MS SQL table STORES if relates with tables SALES and DISCOUNTS through the key "stor_id", i necessary of triger to modify the value of this key being that the related tables are changed too.
Necessary of this because the SQL Server 7,0 does not have update in cascade!
I thought about excluding the data and inserting again changing the heat of the key stor_id, but in mine case the relationship has 38 tables and is half complicated to make this! Debtor!