批量更新关联表(oracle、sql server)

update employee  set hrdeptname=
(select d.DEPTNAME from DEPARTMENT d
where ROWNUM=1 and d.deptID=employee.hrdeptID
)

Update employee set hrdeptname=d.DEPTNAME
from DEPARTMENT  d  inner join employee e  on e.HRDEPTID=d.DEPTID
where 1=1;

update publish  set contentid=
(select top 1 articles.contentid from articles
where articles.articleID=publish.objectID
)
--where publish.objectid=@objectID

SET NOCOUNT ON
DECLARE @contentID int
declare @objectID int
declare @countnumber int
set @countnumber=0
DECLARE publish_cursor CURSOR FOR
    select a.contentid,a.articleID from publish p
    inner join articles a  on a.articleID=p.objectID
    where objectid>0 and p.contentid<> a.contentid
    and (p.cellid=160 or cellid=138)
    OPEN publish_cursor

    FETCH NEXT FROM publish_cursor
    INTO @contentID,@objectID

        WHILE @@FETCH_STATUS = 0
        BEGIN
        print @contentID
        print @objectID
       
            --修改记录
            update publish set ContentID=@contentID where objectid=@objectID
            --修改结束
            FETCH NEXT FROM publish_cursor into @contentID,@objectID
           
        END
    CLOSE publish_cursor
    DEALLOCATE publish_cursor
   
GO

select p.publishid,p.contentid,a.contentid,p.objectID,a.articleID from publish p
inner join articles a  on a.articleID=p.objectID
where objectid>0 and p.contentid<> a.contentid
and (p.cellid=160 or cellid=138)
go

-- update publish set contentid=0 where (cellid=160 or  cellid=138)
-- select * from publish p  where ( p.cellid=160 or  cellid=138)

update publish  set contentid= a.contentid
from articles a  inner join publish p on p.objectID=a.articleID
where cellid=138

-- select * from publish where cellid=138
-- update publish set contentid=0 where cellid=138