sqlserver datetime主键数据不能删除为什么

[baodanerliu]

sqlserver数据库，数据结构如下
COLUMN_NAME DATA_TYPE DATA_LENGTH DATA_PRECISION DATA_SCALE NULLABLE DATA_DEFAULT IDENTITY
------------ --------- ----------- -------------- ---------- -------- ------------ --------
USERID int NO
CHECKTIME datetime NO (getdate())
CHECKTYPE varchar 1 YES ('I')
VERIFYCODE int YES (0)
SENSORID varchar 5 YES
WorkCode int YES (0)
有条数据是这样的
USERID CHECKTIME CHECKTYPE VERIFYCODE SENSORID WorkCode
--------- ------------------ ------------ ------------- ----------- -----------
292 2011-3-1 上午8:27:31 I 1 1 0

sql语句是这样:DELETE FROM CHECKINOUT WHERE userid=292 and checktime='2011-3-1 8:27:31'
为什么不能删除这条数据？每次执行都会显示
Command was executed successfully

大侠们救命啊

[baodanerliu]

TO_DATE 不能再sqlserver中用，只能在oracle中用

[康派尔]

我看主要是你的这句话checktime='2011-3-1 8:27:31'和数据库里的checktime的值不对应当然闪不到了但是执行是成功的就是影响的数据行数是0而已，你数据库的数据是checktime='2011-3-1 上午8:27:31'你可以按照子试一下。

[baodanerliu]

执行 SELECT * FROM CHECKINOUT WHERE userid=292 and checktime='2011-3-1 8:27:31'
还能检索出数据
USERID CHECKTIME CHECKTYPE VERIFYCODE SENSORID WorkCode
--------- ------------------ ------------ ------------- ----------- -----------
292 2011-3-1 上午8:27:31 I 1 1 0
我开始怀疑是时间问题，于是
执行 DELETE FROM CHECKINOUT WHERE userid=292 这条语句，结果还是 Command was executed successfully，这条数据还是没删除
插入数据没问题，就是不让修改和删除

[lh_fengyuzhe]

把checktime转换为日期格式看看

[lh_fengyuzhe]

DELETE FROM CHECKINOUT WHERE userid=292 and checktime=to_date('2011-3-1 8:27:31','yyyy-mm-dd hh24:mi:ss')