| Author: Ramalingam S 23 Aug 2006 | Member Level: Gold | Rating:  Points: 2 |
Here's a code which you can use.
This will make sure that if u insert any value to your first table, it will automatically get inserted into second table.
CREATE TRIGGER TestInsert
ON [yourFirsttable]
FOR INSERT
AS
INSERT INTO [yourSecondtable]
SELECT * FROM inserted
|