CREATE TABLE [T_users](
[yhbm] [varchar](20) NOT NULL,
[pwd] [varchar](20) NULL)
CREATE TABLE [dbo].[tUsers](
[usersName] [varchar](50) NOT NULL,
[usersPwd] [varchar](50) NOT NULL)
CREATE Trigger [dbo].[truUser2]
On [dbo].[tUsers] --在tuser表中创建触发器
for Update --为什么事件触发
As --事件触发后所要做的事情
if Update(usersPwd)
begin
ALTER TABLE T_users DISABLE TRIGGER [truUser] ---关闭T_users的触发器
Update dbo.T_users
Set pwd=i.usersPwd
From dbo.T_users br , Deleted d ,Inserted i --Deleted和Inserted临时表
Where br.yhbm=d. usersName
ALTER TABLE T_users ENABLE TRIGGER [truUser]
end
ALTER Trigger [dbo].[truUser]
On [dbo].[T_users] --在tuser表中创建触发器
for Update --为什么事件触发
As --事件触发后所要做的事情
if Update(pwd)
begin
ALTER TABLE tUsers DISABLE TRIGGER [truUser2] --关闭tUsers表中的触发器
Update dbo.tUsers
Set usersPwd=i.pwd
From dbo.tUsers br , Deleted d ,Inserted i --Deleted和Inserted临时表
Where br.usersName=d.yhbm
ALTER TABLE tUsers ENABLE TRIGGER [truUser2]
end