create trigger trgname on students
instead of update
as
update a
set a.id=(case when isnull(b.id,'')='' then c.id else b.id end),
a.name=b.id,
a.address=b.address
from students a full join inserted b on a.id=b.id
join deleted c on a.id=c.id
instead of update
as
update a
set a.id=(case when isnull(b.id,'')='' then c.id else b.id end),
a.name=b.id,
a.address=b.address
from students a full join inserted b on a.id=b.id
join deleted c on a.id=c.id
解决方案 »
- 一个导出为xlsx的问题
- 当数据库中使用varchar类型时,使用的字符集和编码方式是怎样的?
- 问一个sql server 2005的快捷键。(如何快速找到表)
- c#操作access出问题了!在线等,急!!!!!
- 通过ID和字典表名得到名称的函数
- pb9+microsoft sql server 2005 Developer 开发系统,如何在不在客户端安装sql server 2005,就能连接上数据库?
- 很急:一个小问题
- 其实这个问题蛮有难度的
- 麻烦一下各位老兄!!!如何把EXCEL数据表转变为ASSECC数据库?急用!非常感谢!!!
- 求解决:一个表中的两条相似数据以其中一条为主合并成一条
- 还是 分组显示的问题
- 求一个简单的查询语句,up有分
FOR UPDATE
AS
if update(不能更新的字段)
begin
update XXXX
set XXXXX.不能更新的字段=deleted.不能更新的字段
from XXXX,deleted
where XXXX.Id=deleted.Id
end
instead of update
as
update students set id='',address='北京路' where name='李明'
if(select id from inserted where name='李明')=''
begin
update students set id=(select id from deleted where name='李明') where name='李明'
end
FOR UPDATE
AS
if update(不能更新的字段)
begin
rollback tran --回滚掉事务就行了
end