select * from log as a ,(select message from log group by message having count(*)>1) b where a.message =b.message
update sys_point t set t.location = (select s.location from atmsqhd.sys_point s where t.pointcode = s.pointcode) where exists (select 1 from atmsqhd.sys_point s where s.pointcode = t.pointcode )
create or replace view view_operate as select traceuuid, tracetype, tracetime, tracecontentid, userid, userip, isfaile, departmentid, username, departmentname from sys_operationtrace union select traceuuid, tracetype, tracetime, tracecontentid, userid, userip, isfaile, departmentid, username, departmentname from sys_operationtrace_his;
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
http://it.oyksoft.com/post/641/