CREATE TRIGGER cdb_members_update_trigger ON cdb_members
after update
as
begin
update a set [money]=i.credits from coc_members a join inserted i on a.username=i.username
end ;
after update
as
begin
update a set [money]=i.credits from coc_members a join inserted i on a.username=i.username
end ;
解决方案 »
- SQL SERVER 2000 DTS导出数据的问题
- 请教统计某客户按货号和单价分组的,并显示最后日期那笔记录的各个字段
- 求最新插入数据库中的记录
- 公司服务器上的SQL SERVER怎样禁止局域网内的机器连接,但是可以提供WEB服务,或者限制某一个IP可以连接
- 结构化异常处理
- 一个非常奇怪的问题,请各位高手帮忙(在线急!!!!!!!!!!!!!!!!!!!!!!!!!)
- 问一SQL的写法
- 高手请进,这个SQL语句太难了?续集4!
- 求救:执行SQL语句遇到的问题!?
- 求大神帮忙看下SQL Server2008查询select * from t_book where 1=1 and bid = 1 语句报错
- 求:关于在SQL SERVER 根据公式表更新表记录的做法(50分,我只有这么多了)
- 谁来帮我看看我这存储过程哪里错了?
after update
as
update coc_members set money=(select credits from inserted b) where coc_members.username=b.username
go
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON cdb_members
after update
as
begin
update a set [money]=i.credits from ' at line 1
ON cdb_members FOR EACH ROW
begin update coc_members set money = NEW.credits
where coc_members.username = OLD.username
end ;
delimiter ;