Trigger vs Stored procedure

[SqlBeginner]

I am wanting to write a procedure that will insert new/updated fields into another table

 

Ex: tblStaff and tblUsers

 

Fields in tblUsers needs to be inserted into tblStaff when new records or added or fields are updated. What is the best route to go to accomplish this?

[justsomeguy]

Triggers and stored procedures are used for different things. If you want something to happen when records are added or updated then you use a trigger for that. Your trigger can run a stored procedure if you want it to.

[SqlBeginner]

OK so there is a trigger on the table that add/updates information and I would need to write the stored procedure to have that information updated to the second table?

[justsomeguy]

You can write a stored procedure, or just write the code in the trigger. A stored procedure would make sense if you would run it from places other than just the trigger.

[SqlBeginner]

DELIMITER //CREATE PROCEDURE GetOfficeByCountry(IN countryName VARCHAR(255))BEGINSELECT city, phoneFROM officesWHERE country = countryName;END //DELIMITER ;

 

Will you explain delimiter and the reason for the information in ()

[justsomeguy]

You should probably read up on stored procedures if you don't understand that. The delimiter keyword changes the end-of-statement delimiter. They change it before defining the stored procedure so that the entire create procedure is seen as a single statement, and then they change it back to the default after defining the procedure. The parameter in parentheses defines a variable called countryname that is an input varchar variable.

[SqlBeginner]

I have been looking over stored procedures for quite some time now and can't seem to find an example of what I'm wanting to do. I'm wanting to pull certain fields from database A to be inserted into database B and update accordingly. I was first attempting to write one procedure but then was looking at writing a stored procedure in A and then calling the procedure in B and then inserting there...