您可以使用 INSERT over DML
它来实现：
INSERT INTO tab_name(FromRoleID, ToRoleID, TableRelationshipTypeID)SELECt FromRoleID, ToRoleID, TableRelationshipTypeIDFROM ( MERGE INTO Party.TableRelationship AS old USING TableRelationship AS new ON new.TableRelationshipTypeID = old.TableRelationshipTypeID AND old.ToRoleID = @RoleID WHEN MATCHED THEN UPDATe SET old.ThruDate = GETDATE() OUTPUT $action, FromRoleID, ToRoleID, TableRelationshipTypeID) sub(action, FromRoleID, ToRoleID, TableRelationshipTypeID)WHERe action = 'UPDATE';
请记住，此方法有一些局限性，更多信息： MS
Connect
