[mountainman]

Hope this will help

CREATE TRIGGER [ schema_name . ]trigger_name
ON table_name
AFTER
INSERT
AS
@Username = select id from inserted
insert into AUTHEN(us,pw) values(@username,'password')
go