当前位置: 代码迷 >> Sql Server >> access剔除语句删除不了
  详细解决方案

access剔除语句删除不了

热度:66   发布时间:2016-04-27 11:53:34.0
access删除语句删除不了
DELETE *
FROM AddFreon
WHERE StartTime = # 12-07-17 16:22:48 #
为什么删除不了内容,崩溃了!

------解决方案--------------------
SQL code
DELETE FROM AddFreonWHERE StartTime = # 12-07-17 16:22:48 # 注:数据库中要有StartTime =# 12-07-17 16:22:48 #的行数
------解决方案--------------------
DELETE FROM AddFreon
WHERE StartTime = '12-07-17 16:22:48'

delete from 中间不加*
不知道你的#是时间字段里面的字符吗?
------解决方案--------------------
SQL code
DELETE FROM AddFreonWHERE StartTime ='12-07-17 16:22:48'
------解决方案--------------------
探讨
SQL code


DELETE
FROM AddFreon
WHERE StartTime ='12-07-17 16:22:48'




你StartTime字段内容是 # 12-07-17 16:22:48 # ?
  相关解决方案