DELETE FROM FDD_Country WHERE CountryID IN( 1,2,3,100)要实现的功能基本同上,删除FDD_Country表中CountryID 为1,2,3,100的记录. 如果数据库中存在ID为1,2,3的记录,不存在ID为100的记录时需要rollback怎么实现?
這個功能使用事務應該不方便,一旦刪除之後,你怎么知道之前刪除的記錄是否有100呢?所以應該事先判斷IF EXISTS(SELECT * FROM FDD_Country WHERE CountryID=100) BEGIN DELETE FROM FDD_Country WHERE CountryID IN(1,2,3,100) END
DELETE FROM FDD_Country WHERE EXIST CountryID IN( 1,2,3,100) 不知道可以不
BEGIN
DELETE FROM FDD_Country WHERE CountryID IN(1,2,3,100)
END
BEGIN
DELETE FROM FDD_Country WHERE CountryID IN(1,2,3,100)
END
BEGIN
DELETE FROM FDD_Country WHERE CountryID IN(1,2,3,100)
END