Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SP with multiple tables and databases (insert & delete)
Message
 
 
To
01/03/2003 11:22:20
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00758108
Message ID:
00759927
Views:
15
>I guess this is why extreem programming advocates pair programing. With the input of several people you get a better routine than one person would write them selves.
>
>BOb

He-he. Well, this SP is nof finished yet. The most complicated part still remains...

Also I thought today, that I can have CartID stored in session variable and pass it. However, after further consideration, I think, I would leave the beginning of it as it is, because otherwise I would have to check, if it's a valid CartID or not and if it indeed belongs to the UserID
===========
Anyway, I now have another question. When I delete record in CartContent table, in addition to deleting records from CartDetail, I neeed to update ModiDate field in Cart table as well. And also set flag to D. How can I accomplish that? Is trigger the only solution?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform