CREATE TRIGGER [dbo].[XXX_UPDATE]
ON [dbo].[XXX]
AFTER UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @A VARCHAR(50)
DECLARE @B INT
select @A=A,@B=B from inserted
if @B=XX
begin
update XXX set XX=1 where XX in
(
select XX from XX where A=@A
)
end
-- Insert statements for trigger here
END
一个简单的用来更新的触发器,当xx表发生变化后,更新xx表的字段的值
inserted代表xx表变化的那一行
afted 代表xx表变化的那一行之前的数据