请教各位,用ADOQUERY如何才能一次性删除一个DBF表中的多条记录?
这样的SQL语句应该如何写?我试着这样写,但好象不起作用
DELET FROM TJTMP.DBF WHERE CHI_BRF IN ('安顺','毕节','遵义','铜仁')非得分写为下面的才行
DELET FROM TJTMP.DBF WHERE CHI_BRF ='安顺'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='毕节'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='遵义'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='铜仁'
这样的SQL语句应该如何写?我试着这样写,但好象不起作用
DELET FROM TJTMP.DBF WHERE CHI_BRF IN ('安顺','毕节','遵义','铜仁')非得分写为下面的才行
DELET FROM TJTMP.DBF WHERE CHI_BRF ='安顺'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='毕节'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='遵义'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='铜仁'
这样的SQL语句应该如何写?我试着这样写,但好象不起作用
DELET FROM TJTMP.DBF WHERE CHI_BRF IN ('安顺','毕节','遵义','铜仁')非得分写为下面的才行
DELET FROM TJTMP.DBF WHERE CHI_BRF ='安顺'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='毕节'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='遵义'
DELET FROM TJTMP.DBF WHERE CHI_BRF ='铜仁'
你的Delete 都写错了!
如果可以,直接用sql server 方便多了。
地名是随机产生,应该如何处理?
再去试试!