添加双主键
altertableTChargeRecordMainNewaddconstraintpk_nameprimarykey(任务编码,序号)
-------------------------用于ETL数据库同步复制------------------------------------数据库开启dcdEXECUTEsys.sp_cdc_enable_db;
--需要监听的表EXECsys.sp_cdc_enable_table'dbo','TChargeRecordMainNew',@role