下面语句哪里写错了？为何会报错

Question

下面语句中加了 where后面的 一个条件（红色部分）就报错，报错字段不存在？ 是哪里写错了呢？"SELECT "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&"from "&chr(34)&"HPD:HelpDesk"&chr(34)&" "&chr(34)&"HPD:HelpDesk"&chr(34)&" WHERE (datediff(mi, "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&",getdate()) > 30) ORDER BY "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&""
但是在select里加Create Time是没有问题的。就是where后面红色部分提示写错，字段不存在。

Answer 1

Create Time？中间有空格吗空格是非标示符，应该用中括号将字段括起来[Create Time]这样

Answer 2

但我select "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&" 这样就没事啊？ 为何select里没事，但到了where后面就不行呢？

Answer 3

那你
SELECT datediff(mi, "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&",getdate())
这样报错吗报的什么错？

Answer 4

报[AR System ODBC Driver]Expected lexical element not found: FROM 
这个错

Answer 5

"SELECT "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&"from "&chr(34)&"HPD:HelpDesk"&chr(34)&" "&chr(34)&"HPD:HelpDesk"&chr(34)&" WHERE (datediff(mi, "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&",getdate()) > 30) ORDER BY "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&""问题出在这里，你这个表不存在

Answer 6

下面语句当中，只要把红色部分去掉就能正常执行。 
   objCommand.CommandText = "SELECT "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&", "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&", "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&", "&Chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Resolved Time"&chr(34)&" from "&chr(34)&"HPD:HelpDesk"&chr(34)&" "&chr(34)&"HPD:HelpDesk"&chr(34)&" WHERE ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To Group+"&chr(34)&" Like "&chr(39)&"%apac.gen.as%"&chr(39)&") AND ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Status"&chr(34)&" = "&chr(39)&"Assigned"&chr(39)&")AND (("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Guangjun Yuan"&chr(39)&") OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Usha Kumari"&chr(39)&")OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"ruheng xu"&chr(39)&") OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Alex Xu"&chr(39)&")OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Huabo Ding"&chr(39)&")OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Jack S Li"&chr(39)&")OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Jinzhe Liang"&chr(39)&")OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Lin Yang"&chr(39)&")OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Liang Dai"&chr(39)&")OR ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&" = "&chr(39)&"Satyakam Sahoo"&chr(39)&")) AND (datediff(mi, "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&",getdate()) > 30) ORDER BY "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&""

Answer 7

就是加了下面红色部分就报错，报Column不存在。

SELECT "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&", "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To individual+"&chr(34)&", "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&", "&Chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Resolved Time"&chr(34)&" from "&chr(34)&"HPD:HelpDesk"&chr(34)&" "&chr(34)&"HPD:HelpDesk"&chr(34)&" WHERE ("&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Assigned To Group+"&chr(34)&" Like "&chr(39)&"%apac.gen.as%"&chr(39)&") AND (datediff(mi, "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Create Time"&chr(34)&",getdate()) > 30) ORDER BY "&chr(34)&"HPD:HelpDesk"&chr(34)&"."&chr(34)&"Case ID+"&chr(34)&"" 

Answer 8

错误都告诉你了column不存在
你把sql语句完整的输出出来，在ssms中执行一下，不要弄"&chr(39)&")这些

Answer 9

column不存在的话为什么写在select后面就没有报不存在的错误呢？

Answer 10

看着就晕了，用Profiler跟踪一下执行的语句吧