Trigger in Sql Server

[nzhmz]

Hi,

I am using sql server as my database.

i have two tables (Assume A and B). i want to update a value to a field in my table A. (lets assume the value is X which is an integer) when i insert the value to the field in table A i want the value X to be also updated in a field in table B.

can i do this using a trigger or do i have to use a stored procedure or a user defined function what is the best method to do this please help me to get this done.

Thanks in advance.
really appreciate ur replies.

 

[cjard]

i'd use a trigger. actually i'd see if the two tables could be combined as youre implying the relationship between them is 1:1