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 |
|
mela
Starting Member
2 Posts |
 Posted - 2005-03-27 : 22:21:22
|
| I'm working on a database where i currently have a table with active and inactive product and i wish to move all the inactive products to a new inactive product table.But i want to add the flexibility of whenever the status change for a product, that product will be moved automatically to the proper table without any manual execution.I want to ask here how many ways is there for me to do the above and how do i do it?For example, do i setup a trigger to capture the status change?Thanks in advance |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-03-28 : 01:22:40
|
| If you want to move data to the new table, then you can use triggerMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Automated procedure calling