Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the difference between ACCESS and SQL Server Like date type query". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what are the differences between ACCESS and SQL Server Like date type queries?"

The usage of LIKE in ACCESS

The use of like wildcards in Access is as follows:

"?" Represents any single character; "*" represents zero or more characters; "#" represents any number

So it should be:

Select * from databasename where fieldname like'* XX*'

But in SQL SERVER,% is used to represent zero or more characters.

Second, how to query the date range data of datetime type fields in ACCESS

If the field is time / date, you are doing something like this

Select * from [card] where [datetime] = '2006-09-01'

If you will report an error in ACCESS, you should add "#" before the date field, that is:

Select * from [card] where [datetime] = # 2006-09-01

At this point, I believe you have a deeper understanding of "what is the difference between ACCESS and SQL Server Like date type query". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.