这样的存储过程应该怎么写？

[FlyingQQ]

我有表A和表B
A:
ID VALUE TYPE
B:
ID A_ID VALUE TYPE
A为B的索引表,客户要求，根据不同的用户要求，能修改索引的数据，新的索引数据从B中得到，而旧的索引数据替换B中的原有数据，可是我不知道该如何写才能把A表的数据和B中的数据进行交换，哪位大侠帮忙写写～！

[txlicenhe]

Select * into #tmp from A
update A set a.value = b.value,a.type = b.type from A join b on a.id = b.a_id
update B set b.value = a.value,b.type = a.type from #tmp a join b on a.id = b.a_id

[pengdali]

update b set value=a.value from a where a.id=b.a_id

[zjcxc]

update b set value=a.value from a where a.id=b.a_id

[LoveSQL]

Select * into #tmp from A
update A set a.value = b.value,a.type = b.type from A ,b where a.id = b.a_id
update B set b.value = a.value,b.type = a.type from #tmp a , b where a.id = b.a_id