1.表中有自增字段xh
select max(xh) from tablename
update tablename set memo='%s' where xh='%s'
2.表中有不自增的主键id
delete from tablename where id='%s'
select 999999999 as 'id'
3.SQL server里面会用到的语句
CDC数据抽取模式:
exec dbo.usp_cdc_pacs %执行存储过程
update CM_GXRQ_MANAGEMENT set max_gxrq_cdc=0x0000000000000002 where tablename='RIS_RESULT' %解决的问题:为过程或函数 cdc.fn_cdc_get_net_changes_ ... 提供的参数数目不足
时间戳模式和字典模式:(部分程序来源,数据抽取包)
if