Batch update insert

xiaoxiao2021-03-06  15

INSERT INTO DBO.TAB (RR_ID, RR_SELECT_ID) SELECT RR_ID, RR_SELECT_ID, from DBO.TABETEMP Where Not Exists (Select Distinct RR_ID from DBO.TAB WHERE DBO.TAB.RR_ID = DBO.TABETEMP.RR_ID)

Update dbo.tab set detail_iscalled = feetemp.isspotcheckedfrom (selectpotcheckedfrom (selection id, questionpotchecked from tabetemp) as feetemp where dbo.tab.id = feetemp.id

转载请注明原文地址:https://www.9cbs.com/read-65324.html

New Post(0)