how to execute stored procedure inside instead of trigger

Question

3.77/5 (3 votes)

See more:

Hello,

I have a table in which record is inserted from both third party tool and also from one procedure so that duplicate record occur there i want to set a trigger in it so that if duplicate record found then it will not insert if not then it will insert through that procedure but how to call procedure in instead of trigger or any other way to insert from any side third party or from procedure.

Thanks & regards
Srishti

Posted 14-Aug-14 0:14am

srishti_

Add a Solution

3 solutions

Solution 1

Hi,

Check this...

Using Trigger to Call a stored procedure[^]

Hope this will help you.

Cheers

Posted 14-Aug-14 1:15am

Magic Wonder

Solution 3

You can:
Use a BEFORE INSERT trigger to
not do the insert if the key value already exists (raise an error)
to delete the other row directly or call a stored procedure that deletes the other row.

Use an AFTER INSERT trigger to raise an error if the key value exists

Use a unique constrint to prevent the entry of duplicate data

I would suggest that you don't try to delete the inserted row that is causing a trigger to fire.

Posted 14-Aug-14 11:17am

PhilLenoir

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mangesh4 · Accepted Answer · 2014-08-14T01:35:00

Solution 2

Hi Srishti

No its not possible.
Because its basic rule you can not call procedure from function.
Trigger is special function which will fired after any event occurred on table or database.

For this purpose,you have to handle manually.

Thanks
Mangesh

Posted 14-Aug-14 1:35am

Mangesh4

Comments

srishti_ 14-Aug-14 7:37am

ok thanks

PhilLenoir 14-Aug-14 17:06pm

A trigger is not a function, it is a stored procedure itself. You can call a stored procedure from within a trigger, although you might have issues if the stored procedure causes the trigger to fire or if the trigger is a before trigger and the stored procedure is to work with the rows that fired the trigger.