sql查询优化--数字转换字符串字段 SELECT top 1 pt.* FROM t1where id='20180731223014' SELECT top 1 pt.* FROM t1where id='0180731223014 ---字段值没加单引号导致了索引扫描