摘要:
UPDATE dbo.DEVICE_BIT_NUMBERSET code = substring(code,1,1) + substring(code,6,5) +substring(code,2,4) + substring(code,11,4) WHERE CODE LIKE '%ZNZM%';UPDATE dbo.DEVICE_BIT_NUMBERSET code = replace(code ,'-','_') WHERE CODE LIKE '%ZNZM%';SELECT substring(code,1,1) FROM
阅读全文