I have two tables (tbl_A and tbl_B) which each have 4 text fields. I am trying to use a stored proc to update one table with values from the other.

How do I take the data from one specific row in tbl_A and update the corresponding row in tbl_B?

I'm using MS SQL Server 7.0