Trigger to update table.

[parshupooja]

Hey All

I have table Employee which has coluumns (id, name, address, ssn, DOB, date of join,level etc )employee records. Everytime there is new employee in company, there is new entry in Employee table.
I have another table User which has three columns (id, user, password) which consists name of all current employee in user column and ther password is name+123.

I want to write a trigger which automatically should update the User table with name, name +123 of new user when new employee is added to Employee table.

Do help,
Thanks

[debasisdas]

Kindly post what you have tried so far.

[parshupooja]

I haven't wriiten anything since I don't know much abt Triggers

Kindly post what you have tried so far.

[krishnaraj]

This is the trigger

CREATE TRIGGER your_trigger_name
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

[parshupooja]

Thanksssssssssssssssssss

This is the trigger

CREATE TRIGGER your_trigger_name
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

[ck9663]

here's more about trigger

-- ck