deletedemo2.sql

来自「100多个SQL小程序,包含游标,基本增删改查,希望多你有用」· SQL 代码 · 共 19 行

/* 文件名称: DeleteDemo2.sql */
USE 北风贸易
GO

SET NOCOUNT ON
GO

BEGIN TRANSACTION MyTransaction

SELECT COUNT(*) FROM 客户

DELETE 客户
  WHERE 客户编号 NOT IN
       (SELECT DISTINCT 客户编号 FROM 订货主档)

SELECT COUNT(*) FROM 客户

ROLLBACK TRANSACTION MyTransaction