sqlserver 中遇到一些不可见字符
select ASCII(SUBSTRING(khdm,8,1))from OrderMain where ckdh='2017031685908'
select ASCII(SUBSTRING(khdm,9,1))from OrderMain where ckdh='2017031685908'今天发现,订单表和客户表通过khdm总是关联不上,后来发现是因为订单表里面khdm总长度是9
原创
2017-03-20 12:35:50 ·
1050 阅读 ·
0 评论