Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Call stored procedure from trigger (multiple records upd
Message
 
 
À
25/02/2007 04:01:07
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01198598
Message ID:
01198648
Vues:
7
You'll have to write a wrapper SP that will accept the list of ItemCode/Qty, process it and pass one by one to your SP. You can use a temproray table to pass the list to a wrapper SP.

>
>I have stored procedure that accept ItemCode, Qty as parameter. This procedure will update Item qty based on item code provided. In this stored procedure, it check for certain rules before update qty.
>
>If I update/delete 10 records using SINGLE update/delete statement, how could I call this SP and pass the relevant parameters?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform