SQL类语法

查询列中是否包含中文

SELECT * FROM  Table WHERE Col like '%[吖-座]%'

DATEDIFF区间查询

SELECT * FROM s_l_loginlog WHERE DATEDIFF(ss,'2018-06-14 16:40:57.000',LoginTime)>=0 AND DATEDIFF(ss,'2018-06-15 15:56:08.000',LoginTime)<=0