Strange select query, now the data will not be queried.

westevil

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.

我是杀人狂

This is possible in SQL. I don't understand it in VC ..

westevil

It is possible to write like this in VC.


You can query the data in other places like this, but this is not the only thing.

fanfan1980

No problem with SQL statement, VC will not understand

5954979

If there is a problem with the single quotes, post the code to see.

pguppgdn

'2017-01-04 23:59:59.999' transformed into a time type!

waxiaoning

Use the profiler to see what the actual SQL statement is running, I think the time in the combined SQL statement is incorrect