How to create a trigger sql

Question

0.00/5 (No votes)

See more:

I would like to seek advice, if you can create sql trigger, which get data from table A, into trigger table, if there has been insert created into table B.

if so, is there example or tutorial I can follow, which cater to this task?

Many thanks

Posted 29-Aug-14 0:00am

miss786

Add a Solution

Comments

Thanks7872 29-Aug-14 6:02am

Search google for Triggers in SQL, thats it. Tons of Tutorials available out there.

3 solutions

Solution 1

Google is your friend here: a simple search "SQL INSERT TRIGGER" found it very, very quickly:
https://www.google.co.uk/search?q=sql+insert+trigger&oq=sql+insert+trigger&aqs=chrome..69i57j0l5.4881j0j7&sourceid=chrome&es_sm=0&ie=UTF-8[^]

Right at the top of the list:
http://msdn.microsoft.com/en-gb/library/ms189799.aspx[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.

Posted 29-Aug-14 0:11am

OriginalGriff

Solution 3

Triggers -- SQL Server[^]

http://www.ehow.com/way_5278946_ms-sql-trigger-tutorial.html[^]

Posted 22-Sep-14 22:39pm

Sibeesh KV

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)

sankarsan parida · Accepted Answer · 2014-08-29T00:12:00

You can write a trigger is fired after an INSERT on the table. Let’s create the trigger as:

CREATE TRIGGER trgAfterInsert ON [dbo].[Employee_Test] 
FOR INSERT
AS
	declare @empid int;
	declare @empname varchar(100);
	declare @empsal decimal(10,2);
	declare @audit_action varchar(100);

        -- Collect data from Table A
	select @empid=i.Emp_ID from inserted i;	
	select @empname=i.Emp_Name from inserted i;	
	select @empsal=i.Emp_Sal from inserted i;	
	set @audit_action='Inserted Record -- After Insert Trigger.';

        -- Insert to second table b by declared variable
	insert into Employee_Test_Audit
           (Emp_ID,Emp_Name,Emp_Sal,Audit_Action,Audit_Timestamp) 
	values(@empid,@empname,@empsal,@audit_action,getdate());

	PRINT 'AFTER INSERT trigger fired.'

Get More info msdn[^]