日期:
select value it form XXXEntities.Table1 as it where It.CreateTime >= datetime'2017-1-1 0:0:01' and It.CreateTime <= '2017-1-3 23:59:59'
枚举:
select value it form XXXEntities.Table1 as it where It.Stauts in {1,2,3}
select value it form XXXEntities.Table1 as it where It.Stauts in {'a','b','c'}
记录备忘