SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:25 PM
| ||||
| ||||
 Automatical table update within a database Hello! We are developping a project using MS-SQLServer 7 and we need a process for the synchronization of 3 tables together. Inserts and updates in the table A should immediately and automatically occur on table C, and updates on table C should also automatically occur on table B. We think that the solution using triggers and stored procedures is the right choice. Could someone with knowledge on stored procedures help us? We need the help soon, this is quite urgent, so we’d be happy to get an answer! If something is not clear just ask! Thanks in advance! E. Keller      |
|
02-28-2008, 07:25 PM
| |||
| |||
| Re: Automatical table update within a database Look at CREATE TRIGGER topic in the BOL "E.Keller" <emmanuel.keller@net2000.ch> wrote in message news:4eed4cad.0401070114.65961769@posting.google.c om... > Hello! > > We are developping a project using MS-SQLServer 7 and we need a > process for the synchronization of 3 tables together. > Inserts and updates in the table A should immediately and > automatically occur on table C, and updates on table C should also > automatically occur on table B. > We think that the solution using triggers and stored procedures is the > right choice. Could someone with knowledge on stored procedures help > us? > We need the help soon, this is quite urgent, so we’d be happy to > get an answer! > If something is not clear just ask! > > Thanks in advance! > E. Keller |
|
02-28-2008, 07:26 PM
| ||||
| ||||
| Re: Automatical table update within a database Use triggers if you cannot guarantee that the process that modifies table A will also do the other two. If you do it all with stored procedures (my preferred method) you can write the modification code for all three tables inside the procs. make sure you wrap the 3 statements in a transaction so they all complete or all roll back. Triggers automatically do the transaction for you, but this is not always a good thing. "E.Keller" <emmanuel.keller@net2000.ch> wrote in message news:4eed4cad.0401070114.65961769@posting.google.c om... > Hello! > > We are developping a project using MS-SQLServer 7 and we need a > process for the synchronization of 3 tables together. > Inserts and updates in the table A should immediately and > automatically occur on table C, and updates on table C should also > automatically occur on table B. > We think that the solution using triggers and stored procedures is the > right choice. Could someone with knowledge on stored procedures help > us? > We need the help soon, this is quite urgent, so we’d be happy to > get an answer! > If something is not clear just ask! > > Thanks in advance! > E. Keller |
Linear Mode
