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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-11 : 07:58:26
|
| Leonel writes "need help with home work,Write a trigger named PostOrderValue which will cause the value of ORDERS.OrderValue to be incremented by PART.Price * ORDER_LINE.Qty whenever a record is INSERTED in the ORDER_LINE table. INSERT several Orders and OrderLines, then use your code to demonstrate -- that the trigger PostOrderValue and the procedure SetReorderFlag are -- working correctly.these are the tables ORDER (OrderNo,OrderDate,CustID,OrderValue)PART(PartNo,PartName,VendorID,Price,QtyOnHand,)ORDER_LINE(OederNo,OrderLine,PartNo,Qty) " |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-11 : 08:05:39
|
what do you have so far?  Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-11 : 08:18:58
|
No homework please!  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
create trigger