2012年3月9日
Oracle和SQL Server连接表的更新操作Update SQL 语句
摘要： For Oracle:update ipop_worktype_loader wl set wl.status=0where exists (select 1 from ipop_worktype_lkp w where wl.worktype_id = w.worktype_id and w.application_Id=10 and wl.status=1)For MS SQL Server:update wl set wl.status=0 from ipop_worktype_lkp w,ipop_worktype_loader wlwhere wl.worktype_id = w.w 阅读全文
posted @ 2012-03-09 15:16 骨头森林 阅读(2099) 评论(0) 推荐(0)