sql之间的错误 [英] error at sql between

问题描述

sSQL =

  SELECT  *  FROM  tbl_Record  WHERE  [日期]  > =  &格式（fdate.Value， MM / dd / yyyy  ）&   AND < =  &格式（tdate.Value， MM / dd / yyyy  ）&  

i这个部分总是出错......

语法错误（缺少运算符）在查询表达式'[Date]之间> = 10/21/2014 AND< = 11/03/20014'。



可以有人帮忙我...没有错误的迹象...

提前感谢...

解决方案

正确的陈述是：

  SELECT  * 
  FROM  tbl_Record 
  WHERE  [日期]  BETWEEN  '  2014-09-03'  AND  '  2014-11-03' 

符号<<和>省略BETWEEN语句时需要。

  SELECT  * 
  FROM  tbl_Record 
  WHERE  [日期]> = < span class =code-string>'  2014-09-03'  AND  [ 日期]< = '  2014-11-03'  

两个查询都相同。



注意：

不要使用这样的查询。使用存储过程 [ ^ ]。

如何使用之间运营商



http：// www.w3schools.com/sql/sql_between.asp [ ^ ]

sSQL = "

SELECT * FROM tbl_Record WHERE [Date] between >=" & Format(fdate.Value, "MM/dd/yyyy") & " AND <=" & Format(tdate.Value, "MM/dd/yyyy") &

""


i always got error in this part...
Syntax error (missing operator) in query expression '[Date] between >=10/21/2014 AND <=11/03/2014'.

can someone help me... no indication of error...
thanks in advance...

解决方案

The proper statement is:

SELECT *
FROM tbl_Record
WHERE [Date] BETWEEN '2014-09-03' AND '2014-11-03'

Symbols << and > are needed when you omit BETWEEN statement.

SELECT *
FROM tbl_Record
WHERE [Date] >= '2014-09-03' AND [Date] <= '2014-11-03'

Both queries are equal.

Note:
Do not use such of queries. Use stored procedured[^] instead.

how to use between operator

http://www.w3schools.com/sql/sql_between.asp[^]

这篇关于sql之间的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！