Insert Trigger

				
--**************************************
-- Name: Insert Trigger
-- Description:Takes Newly Inserted Values and place them in another table.
-- By: DECIS
--
-- Inputs:just your SQL.
--
-- Returns:Inserts values into another table as they are inserted into a table.
--
-- Assumes:This code will take values from one table and place them in another as they are inserted. Just change the Select and Table Names Except the table Inserted as this is a temp table used to store values as they are inseted.
If you are an experienced DBA you probably cant belive that someone does not know how to do this, but Im no DBA just a programmer and It took me a while to figure out so I hope it can help if youre struggling as I was.
--
-- Side Effects:None.
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=269&lngWId=5--for details.--**************************************

CREATE TRIGGER [trg_Create_History_Item] ON tbl_Data_Protection
FOR INSERT
AS
INSERT INTO 
tbl_DATA_Protection_History(DP_ID,[NAME],TITLE,FORE,[INIT],SURN,THIRD_PARTIES,
THIRD_PARTIES_DTE,CONTACT,CONTACT_DTE,MAIL,MAIL_DTE,TELEPHONE,TELEPHONE_DTE,FAX,FAX_DTE,
EMAIL,EMAIL_DTE,EX_DIRECTORY,EX_DIRECTORY_DTE,TEL_NO,FAX_NO,COMPASS_KEY,FC_NOTICE_DATE)
SELECT DP_ID,[NAME],TITLE,FORE,[INIT],SURN,THIRD_PARTIES,
THIRD_PARTIES_DTE,CONTACT,CONTACT_DTE,MAIL,MAIL_DTE,TELEPHONE,TELEPHONE_DTE,FAX,FAX_DTE,
EMAIL,EMAIL_DTE,EX_DIRECTORY,EX_DIRECTORY_DTE,TEL_NO,FAX_NO,COMPASS_KEY,FC_NOTICE_DATE
FROM Inserted