This is the trigger

CREATE TRIGGER your_trigger_na me
ON Employee
FOR INSERT AS
BEGIN
INSERT User (Name,Password)
SELECT Name, Name + '123' FROM INSERTED
END

Substitute the column names if they are different in your table, Because there are some reserved words in these names

Krishnaraj