Question

用户要按照时间来模糊查询sql语句怎么写，比如，写个”2010-03“

Answer 1

select * from table1 where datepart(yyyy,colume1)="2010" and datepart(mm,colume1)="03"

Answer 2

select * from table where time like "2010-03%"

Answer 3

select * from table where time like '%2010-03%'
是单引号