一个简单的触发代码CREATE TRIGGER UpdateArea_BulidNum_DelTri ON Bulid
AFTER DELETE
AS
Declare @BulidNum int,
@BulidNum = select count(*) from Bulid --这样写是错的,请问该如何写呢?BEGIN
Update Area Set BulidNum = @BulidNum - 1
Where AreaNo IN(SELECT AreaNo FROM DELETED)
END
AFTER DELETE
AS
Declare @BulidNum int,
@BulidNum = select count(*) from Bulid --这样写是错的,请问该如何写呢?BEGIN
Update Area Set BulidNum = @BulidNum - 1
Where AreaNo IN(SELECT AreaNo FROM DELETED)
END
AFTER DELETE
AS
Declare @BulidNum int,
select @BulidNum =count(*) from Bulid --这样写是错的,请问该如何写呢?BEGIN
Update Area Set BulidNum = @BulidNum - 1
Where AreaNo IN(SELECT AreaNo FROM DELETED)
END
SQL语法都忘光了!呵呵,原来这么简单。
CREATE TRIGGER UpdateArea_BulidNum_DelTri ON Bulid
AFTER DELETE
AS
Declare @BulidNum int
select @BulidNum =count(*) from Bulid
BEGIN
Update Area Set BulidNum = @BulidNum - 1
Where AreaNo IN(SELECT AreaNo FROM DELETED)
END