I want to combine these two triggers in to single trigger .how to do that

Question

1.00/5 (1 vote)

See more:

SQL

CREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] AFTER INSERT
AS

BEGIN

INSERT INTO  tablename_history
SELECT * FROM INSERTED


PRINT 'AFTER INSERT Trigger fired.'
END

SQL

CREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] FOR UPDATE
AS

BEGIN

INSERT INTO tablename_history

SELECT * FROM DELETED

PRINT 'FOR UPDATE Trigger fired.'
END

Posted 18-Mar-14 20:11pm

Member 10501509

Updated 18-Mar-14 22:40pm

v2

Add a Solution

Comments

Andrius Leonavicius 19-Mar-14 5:18am

Hi,

You have already asked a similar question. I have already answered to your question, haven't I?
http://www.codeproject.com/Answers/745934/I-have-created-trigger-for-after-insert-now-how-to#answer2

Note: Ask in the comments if something is not clear about the given answer. If you want to edit or improve your question, you can do that by clicking on "Improve Question" link.

Andrius Leonavicius 19-Mar-14 5:35am

By the way, I just noticed you're using AFTER INSERT, but FOR UPDATE trigger. AFTER and FOR triggers do the same thing, there is no difference. An INSTEAD OF trigger is different than FOR/AFTER.
So use AFTER INSERT, UPDATE or FOR INSERT, UPDATE...

1 solution

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)

Guruprasad.K.Basavaraju · Answer 1 · 2014-04-01T15:00:00

You can add INSERT and UPDATE in the same create statement separated by a comma. Something like below

For more info on Create TRIGGER refer : http://msdn.microsoft.com/en-us/library/ms189799.aspx

SQL

CREATE TRIGGER [dbo].[triggername] ON [dbo].[tablename] AFTER INSERT, UPDATE
AS

BEGIN

IF EXISTS(SELECT * FROM DELETED)
  BEGIN
    SELECT * FROM DELETED;
  END

ELSE 

  BEGIN
    INSERT INTO  tablename_history;
    SELECT * FROM INSERTED;
  END 

 

PRINT 'AFTER INSERT/UPDATE Trigger fired.';
END