sql查询优化--数字转换字符串字段

SELECT top 1 pt.* FROM t1where id='20180731223014'

SELECT top 1 pt.* FROM t1where id='0180731223014   ---字段值没加单引号导致了索引扫描