|
There are select statements as below, where ... means omit some query fields.
select AA. [ID], AA. [NO], ... AA. [Memo]
from [Table] as AA
where AA. [CreateDate]> = '2016-12-05 00: 00: 00.000'
and AA. [CreateDate] <= '2017-01-04 23: 59: 59.999'
order by AA. [NO] desc
This statement was placed in VC using ADO Recordset, but it did not query any data records, but when it was placed in the query analyzer, it could query many eligible records.
Why is this?
The field CreateDate is a datetime type.When querying, I use the string method as a conditional query. |
|