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 |
|
kallileo
Starting Member
21 Posts |
 Posted - 2007-03-05 : 07:33:25
|
| I have a table with columns Suppliers Name, Product and Quantities.I also have another auxiliary table where I insert records(Supplier Name, Product and Quantities) from an external application. What I want is when I insert records in the second table the corresponding records of the main table to be updated and all the records in the auxiliary to be deleted.Do I have to use stored procedures???? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-05 : 07:39:48
|
You can use stored procedure or trigger to achieve this.
KH |
 |
|
|
kallileo
Starting Member
21 Posts |
Posted - 2007-03-05 : 07:51:53
|
Any examples or tutorials???? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Connecting Tables