小鸡飞过海的个人空间 http://space.itpub.net/12513946 Copyright(C) 小鸡飞过海的个人空间 SupeSite/X-Space Thu, 20 Nov 2008 21:36:13 GMT 关于merge into 的使用 http://space.itpub.net/12513946/viewspace-151855 merge into 的用法如下：

merge into t_AAA a

using (select t.id, t.time from t_BBB t) b

on (a.id=b.id)

when matched then

update set a.last_time=b.time where b.time>a.last_time

when not matched th...]]> blog 小鸡飞过海 Fri, 18 Jan 2008 18:31:34 GMT