22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER 删除用户
ON 用户信息
FOR DELETE
AS
BEGIN
DECLARE @卡号 VARCHAR(12)
SELECT @卡号 = [Card number]
FROM DELETED
DECLARE @卡号2 VARCHAR(12)
SELECT @卡号2 = [Card number]
FROM 用户信息
WHERE [Card number] = (
SELECT [Card number]
FROM 消费信息
)
BEGIN
DELETE
FROM 用户信息
WHERE [Card number] = @卡号
IF (@卡号 = @卡号2)
BEGIN
DELETE
FROM [Card number]
WHERE [Card number] = @卡号
DELETE
FROM [User name]
WHERE [Card number] = @卡号
DELETE
FROM [User number]
WHERE [Card number] = @卡号
END
END
END