467,915 Members | 1,448 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Table Automatically Populating with Data from another table

So I am working on this project, where I have an ITEM_PURCHASE table and an WAREHOUSE table I want users to be able to input data into the ITEM_PURCHASE table thru a form and the WAREHOUSE table will automatically populate from certain fields in ITEM_PURCHASE. In this scenario should I use a trigger or stored procedure? Can someone provide the SQL code to get me started? Can someone help me out here, it will be greatly appreciated.

Thanks
Nov 9 '08 #1
  • viewed: 1284
Share:
1 Reply
ck9663
Expert 2GB
Trigger would be better for this one. Just use transactions to ensure consistency.

-- CK
Nov 11 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

17 posts views Thread by Jon Ole Hedne | last post: by
2 posts views Thread by deko | last post: by
2 posts views Thread by jainharsh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.