Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SP with multiple tables and databases (insert & delete)
Message
 
 
À
01/03/2003 11:22:20
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00758108
Message ID:
00759927
Vues:
28
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform