读书人

access剔除语句删除不了

发布时间: 2012-07-30 16:19:05 作者: rapoo

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 # ?

读书人网 >SQL Server

热点推荐