create TRIGGER [dbo].[updUser]
ON [dbo].[user]
-- 触发时机、条件
after update AS
declare @insertedId int
declare @oldPassWord nvarchar(255)
declare @nwePassWord nvarchar(255)
BEGIN
select @oldPassWord = passWord from deleted;
SELECT @insertedId = id, @nwePassWord = passWord FROM inserted
if (@nwePassWord = @oldPassWord)
begin
update [user] set userName = 'cjxxxxx' where id = @insertedId
end
END
create TRIGGER addUser
ON [user]
-- 触发时机、条件
AFTER insert AS
BEGIN
--SET NOCOUNT ON;
UPDATE [user]
SET passWord='add'
WHERE id IN (SELECT id FROM inserted)
END
insert into [user] values('cj4','cj4');
create trigger delUser
on [user]
after DELETE as
begin
select * from deleted
end
select * from [user]
delete [user] where id = 3;