遇到类似问题的不妨读一下这篇文章先:Access查询和过滤条件 http://www.fontstuff.com/access/acctut06.htm
我遇到的报错语句如下:
update
monitor_table
set
logoffTime
=
'
2008-04-06 16:58:54
'
, keyClickCount
=
'
17
'
where
userName
=
'
abcd
'
and
logonTime
=
'
2008-04-06 16:56:36
'
读了上面的文章,知道 MS Access的时间分隔符号为 # ,而 MS SQL Server的时间分隔符为 '
所以正确的语句应该是:
update
monitor_table
set
logoffTime
=
'
2008-04-06 16:58:54
'
, keyClickCount
=
'
17
'
where
userName
=
'
abcd
'
and
logonTime
=
#
2008
-
04
-
06
16
:
56
:
36
#