readonlybegin begin
merge into dbo.CurrentVersion_1 cvrusing @datatable src on cvr.PackageName =src.PackageName and cvr.env_cloud_roleInstance = src.env_cloud_roleInstancewhen matched and cvr.env_time<src.env_tim
子句的sql查询: SELECT ov.state_nm, ov.state_id,us.client_id, us.rebate_qtr_id, on us.client_id= cvr.client_id
and css.client_id=cvr.client_id[OVT_CLAIM_VALIDATION_ALL_RESULT_USER_
我想创建一个触发器,如果您删除某个存储,它会将该存储中的所有副本分配给另一个预定义存储(cvr)。OR REPLACE TRIGGER delete_trig FOR EACH ROW UPDATE RentalCopy SET cvr= 123456789 END; CONSTRAINT fk_sto