Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2002-04-12 : 22:16:08
|
| I have two tables that I want to update at the same time though the same script. One table would always be updated but the other one would only be updated when the first table has certain information. What is the best way of doing this?Some helpfull info.The table that is always updated: PrivetINFOThe coulmn name is: Doing (This coulmn is always being updted)The table that is updated every now and then: PublicINFOThe coulmn name is: Doing.I want it so when something like this accures that the PublicINFO table is updatedIn Table PrivetINFO coulmn Doing is set at Learning Split Form 7/7 and table PublicINFO coulmn Doing is set at Learning a move. Then when the privetinfo table is update to Normal training (since the person has learned the move) the table publicinfo is automaticly updated to Training.Edited by - Eagle_f90 on 04/12/2002 22:28:32 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-13 : 00:30:02
|
| you can do this thru triggers. to learn about more about triggers, follow this article written by Merkin http://www.sqlteam.com/item.asp?ItemID=6494 .-------------------------------------------------------------- |
 |
|
|
|
|
|
What is the best way to do it?