I am new to sql server . I have to write a trigger to insert the data into
second table when there is any update in first table. Do I have to execute
the trigger every time by some command or it automatically fires when first
table gets updated?

Thanks in advance
Niki

It automatically fires.  Here's a rough example:

create trigger tru_MyTable on MyTable
after update
as

if @@ROWCOUNT = 0
    return

insert MyOtherTable
select
    *
from
    inserted
go


I am new to sql server . I have to write a trigger to insert the data into
second table when there is any update in first table. Do I have to execute
the trigger every time by some command or it automatically fires when first
table gets updated?

Thanks in advance
Niki

Hi Nikila

The difference between Trigger and Stored Procedure is,
You need to execute a stored procedure explicitly, to run the stored procedure

There is no way where you can fire a Trigger from outside. The Trigger is
fired when an operation is performed on a table.

U need a "FOR UPDATE" trigger in your situation

Here is how you do it:

CREATE TRIGGER <TRIGGER_NAME>
ON <TABLE-1>
FOR UPDATE AS

INSERT INTO TABLE-2 SELECT * FROM TABLE-1

GO

For more information about triggers, you can refer: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_7eeq.asp


Show quoteHide quote

Uh, this trigger would insert the entire contents of TABLE-1 into TABLE-2
every time TABLE-1 was updated.

Hi Nikila

The difference between Trigger and Stored Procedure is,
You need to execute a stored procedure explicitly, to run the stored
procedure

There is no way where you can fire a Trigger from outside. The Trigger is
fired when an operation is performed on a table.

U need a "FOR UPDATE" trigger in your situation

Here is how you do it:

CREATE TRIGGER <TRIGGER_NAME>
ON <TABLE-1>
FOR UPDATE AS

INSERT INTO TABLE-2 SELECT * FROM TABLE-1

GO

For more information about triggers, you can refer:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_7eeq.asp


Show quoteHide quote

comparing text fields - Second try
Loading Status on Restore HELP!
disable foreign keys
Login Transfers
SQL 2000 EE SP4 Memory Problem