神奇的sql语句

update netmonitor_obj h set ( monitorstatus ) =(select   monitorstatus from table1 where taskid = '6453f1ac-f1de-45ea-8173-95a2c11b61a0' and historyobjid = h.objid)
where objid in (select historyobjid  from table2 where taskid = 0000)

 

 string sqlinsert = @"insert into net_obj(objid,salesdepartmentid,officeid,countryid,provinceid,prodclassid,network,netdelegateid,interfaceid,netgrade,operator,created_by,creation_date,last_updated_by,issendmail,isactivety,sendmail_count,sendmail_time,monitorstatus,historyname,maintainid,projectid)
                    select objid,salesdepartmentid,officeid,countryid,provinceid,prodclassid,network,netdelegateid,interfaceid,netgrade,operator,created_by,creation_date,last_updated_by,issendmail,isactivety,sendmail_count,sendmail_time,monitorstatus,network2,maintainid,projectid   from TB where taskid='{0}'";
            string sqlUpdate = @"update netmonitor_obj h
                               set (salesdepartmentid,
                                    countryid,
                                    provinceid,
                                    prodclassid,
                                    network,
                                    netdelegateid,
                                    interfaceid,
                                    netgrade,
                                    operator,
                                    created_by,
                                    creation_date,
                                    last_updated_by,
                                    issendmail,
                                    isactivety,
                                    sendmail_count,
                                    sendmail_time,
                                    monitorstatus,
                                    historyname,
                                    maintainid,
                                    projectid) =
                                   (select salesdepartmentid,
                                           countryid,
                                           provinceid,
                                           prodclassid,
                                           network,
                                           netdelegateid,
                                           interfaceid,
                                           netgrade,
                                           operator,
                                           created_by,
                                           creation_date,
                                           last_updated_by,
                                           issendmail,
                                           isactivety,
                                           sendmail_count,
                                           sendmail_time,
                                           monitorstatus,
                                           historyname,
                                           maintainid,
                                           projectid
                                      from  TASK                 where taskid = '{0}'
                                       and historyobjid = h.objid)
                             where objid in
                                   (select historyobjid
                                      from table3                                     where taskid = '{0}')";