Call stored procedure from trigger (multiple records upd

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

John Jones
Kuala Lumpur, Malaisie

25/02/2007 01:58:16

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Stored procedures, Triggers, UDFs

Titre:

Re: Call stored procedure from trigger (multiple records upd

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01198598

Message ID:

01198606

Vues:

Hi,

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?

Thank you

I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...

Répondre

Fil

Voir

Click here to load this message in the networking platform