Abajo encontraras un ejemplo de un Trigger que cuando detecta un Insert en la tabla cacha cuatro campos para despues ponerlos dentro la ejecucion de un stored procedured
--====================================
-- Create database trigger Proveedores
-- para Portal Proveedores
-- A.C.P. 29/07/15
--====================================
ALTER TRIGGER tr_NewVendor ON Vendor
FOR INSERT
AS
BEGIN
Declare @VendID Char(15)
Declare @Name Char(60)
Declare @EMailAddr Char(80)
Declare @TaxRegNbr VarChar(15)
Declare @NewRfc Int
Select @VendID = VendID,
@Name = Name,
@EMailAddr = EMailAddr,
@TaxRegNbr = TaxRegNbr
From Inserted
select @NewRfc=Count(TaxRegNbr) from vendor where TaxRegNbr= @TaxRegNbr
Begin
if @NewRfc = 0
EXEC PrtProv.dbo.Insert_VendorsUsers 0,'','','','','','SYSADMIN',@EMailAddr,'','SYSADMIN',@Name,'','','','',@TaxRegNbr,0,0,@VendId,'','','','','0','0','',0,'I'
END
END
GO