sqlserver--QA

时间：2017-06-20 14:32:30 收藏：0 阅读：306

1.仪表入库后无数据接收处理：

select * from tblfminfo where fmaddress=‘1724181‘ order by createtime desc

select * from tbldatalog where SUBSTRING(REPLACE(SUBSTRING(datalog,25,33),‘ 3‘,‘‘),1,40)=‘64890648615‘ order by createtime desc

原文：http://www.cnblogs.com/1184212881-Ark/p/7053918.html