Both ways work, thanks a lot guys

USE [DEVEL]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[TRASPASO_DESARROLLO2]

ON [dbo].[DATAFEED]

AFTER INSERT

AS

BEGIN

SET NOCOUNT ON

DECLARE @Ric varchar(50), @DATE datetime ,@CIERRE float

select

Im a total noob at SQL SERVER im using a Trigger because I need to know when some data is added to the DATAFEED table so it can be inserted...