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 |
|
shubhada
Posting Yak Master
117 Posts |
 Posted - 2005-10-03 : 05:23:57
|
| I have two tables Details Table and Result Table with same table definition as follow:Detail Table EmpNo EmpName Sal100 ABC 10000200 DEF 20000300 XYZ 15000Result Table:EmpNo EmpName SalWhen I will perform any operation on Detail Table (Update/Insert/Delete) The result should be store in Result Table.Tell me how I can store the result in Result table.shubhada |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-10-03 : 05:28:43
|
Use Triggers - look up "Trigger" in Books OnlineDuane.  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-03 : 05:30:04
|
| You can make use of TriggersHave a look at Triggers in BOL, SQL Server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-03 : 05:31:36
|
 MadhivananFailing to plan is Planning to fail |
|
|
|
anandc
Starting Member
20 Posts |
Posted - 2005-10-04 : 08:01:23
|
| I think the solution for you problem is already given by on this forum...but I'm just wondering why do you need 2 seperate table with the same schema?? - Anand |
|
|
|
|
|
|
SQL help