The below code may help u in finding ur problem

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:<Author,,Name>

-- Create date: <Create Date,,>

-- Description:<Description,,>

-- =============================================

ALTER TRIGGER [dbo].[Insert_Trg_Dept]

ON [dbo].[Dept]

AFTER INSERT

AS

BEGIN

SET NOCOUNT ON;

DECLARE

@EMPID INT,

@DEPTID INT,

@DEPTNAME VARCHAR(50)

SELECT @EMPID=EMPID FROM EMPLOYEE

INSERT INTO DEPT VALUES(@DEPTNAME,@DEPTID,@EMPID)

END