看是否你的条件写错了. try:if exists(select * from stockchange_d where stockchangeid='CGHH200306300001') begin print '准备删除记录' delete from stockchange_d where stockchangeid='CGHH200306300001' if exists(select * from stockchange_d where stockchangeid='CGHH200306300001') print '无法删除' else print '已经成功删除' end else print '无满足条件的记录可供删除'
delete stockchange_d where stockchangeid='CGHH200306300001'
use 你的数据库 select count(*) as 删除前的总记录 from stockchange_d delete stockchange_d where stockchangeid='CGHH200306300001' select count(*) as 删除前的总记录 from stockchange_d
try:if exists(select * from stockchange_d where stockchangeid='CGHH200306300001')
begin
print '准备删除记录'
delete from stockchange_d where stockchangeid='CGHH200306300001'
if exists(select * from stockchange_d where stockchangeid='CGHH200306300001')
print '无法删除'
else
print '已经成功删除'
end
else
print '无满足条件的记录可供删除'
select count(*) as 删除前的总记录 from stockchange_d
delete stockchange_d where stockchangeid='CGHH200306300001'
select count(*) as 删除前的总记录 from stockchange_d
(0 row(s) affected)
(1 row(s) affected)后应该是己经执行成功,但用select 在表里面查询不出来,而我把工号改为12位以内的就可以写进去,不知为什么,请各位大侠指示一下