could you please help me with the code??? I dont know how sqlcmd works...

thanks,

sid

thanks all...

it worked

thanks renuka it worked... instmsdb.sql script can be found in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install

CREATE TRIGGER emp_trig ON humanresources.employee

after UPDATE

AS

INSERT INTO humanresources.employee

SELECT *,DATEDIFF(yy,birthdate,hiredate) YearsPassed FROM deleted

tried the above code but didnot work...

plz help me to correct the code to get the result properly