Trigger Example

Create trigger [dbo].[trgDeleteStagingProducts]
on [dbo].[Vendor_Product]
after insert
as
begin
 DECLARE @VendorProductGUID varchar(50)    
   
    SELECT @VendorProductGUID = I.VendorProductGUID        
      FROM INSERTED I
Delete from Vendor_Product_Stagging where VendorProductGUID = @VendorProductGUID;
end