trigger in sql server 2005

Question

I want to create trigger for one table for insertion...If i insert records in one table then that same records should be inserted to another one......how?

and also explain about triggers

Answer 1

Please have a read of Exploring SQL Server Triggers

Answer 2

This article covers all the basics of creating triggers.

Though for you task i think a stored procedure doing both inserts will be better, because what if one insert succeeded and the other failed? it will create inconsistency in your data. See here for stored procedures.

Answer 3

It should be something like

CREATE TRIGGER TableInserted ON TableInsert
AFTER INSERT
AS
INSERT INTO OtherTable SELECT * FROM inserted

Answer 4

All you need to know about triggers, without having to wade through Microsoft speak, including how to create them in SQL Server.

http://en.wikipedia.org/wiki/Database_trigger