create trigger tr_update_User on zj_User for update as set xact_abort on update a set UserPassword=i.UserPassword,UserEmail=i.UserEmail from zhujishi_web.dbo.zj_User a,inserted i,deleted d where i.[UserName]=d.[UserName] and i.[UserName]=a.[UserName] --改这样试下
update zhujishi_web.dbo.zj_User set UserPassword=i.UserPassword,UserEmail=i.UserEmail from zj_User,inserted i,deleted d --> update zhujishi_web.dbo.zj_User set UserPassword=i.UserPassword,UserEmail=i.UserEmail from zhujishi_web.dbo.zj_User z,inserted i,deleted d
论坛上用户更新信息,只可能是单条记录更新,因此,用不着同时调用inserted 表和 deleted 表.试试: create trigger tr_update_User on zj_User for update as set xact_abort on update t set UserPassword=i.UserPassword,UserEmail=i.UserEmail from zhujishi_web.dbo.zj_User t inner join inserted d where t.[UserName]=d.[UserName]
create trigger tr_update_User on zj_User
for update
as
set xact_abort on
update a set UserPassword=i.UserPassword,UserEmail=i.UserEmail
from zhujishi_web.dbo.zj_User a,inserted i,deleted d
where i.[UserName]=d.[UserName] and i.[UserName]=a.[UserName]
--改这样试下
from zj_User,inserted i,deleted d
-->
update zhujishi_web.dbo.zj_User set UserPassword=i.UserPassword,UserEmail=i.UserEmail
from zhujishi_web.dbo.zj_User z,inserted i,deleted d
create trigger tr_update_User on zj_User
for update
as
set xact_abort on
update t set UserPassword=i.UserPassword,UserEmail=i.UserEmail
from zhujishi_web.dbo.zj_User t inner join inserted d
where t.[UserName]=d.[UserName]
用UPDATE却提示没权限操作,不知道为何,应该是触发器写的不对吧。
换个管理员用户登陆试试?
触发器没问题了
我在本机用VS2010的查询器测试遇到这个问题~~
我远程打开服务器直接用 服务器的数据库管理器测试正常!