关于触发器

rkjk123456 2012-07-12 01:20:21

CREATE TRIGGER [JU_Uint_People_XueliAndZhichengUpdate] ON [dbo].[JU_Unit_People]
FOR UPDATE
AS
IF UPDATE(xueli)
begin
INSERT INTO JU_People_Record(ysxl,id_rl) values(Deleted.xueli,Deleted.id_rl)
end
IF UPDATE(ZhiCheng)
begin
INSERT INTO JU_People_Record(yszc,id_rl) values(Deleted.ZhiCheng,Deleted.id_rl)
end

这是代码 SQL 2000 想实现的是当JU_Unit_People的 xueli和 ZhiCheng字段发生修改时触发但是提示我这里不能用列名。。触发器真不懂请大神们帮帮我

...全文

49 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

rkjk123456 2012-07-12

打赏
举报

(⊙o⊙)… 秀逗了本来打算子查询的然后直接这么写看行不行忘记改了

quchen520 2012-07-12

打赏
举报

[Quote=引用楼主的回复:]
CREATE TRIGGER [JU_Uint_People_XueliAndZhichengUpdate] ON [dbo].[JU_Unit_People]
FOR UPDATE
AS
IF UPDATE(xueli)
begin
INSERT INTO JU_People_Record(ysxl,id_rl) values(Deleted.xueli,Deleted.id_……
[/Quote]

触发器里面可以Deleted.xueli 这样的语法么？

rkjk123456 2012-07-12

打赏
举报

为什么Inset into values 不行 inset into select 就可以真不懂

xuam 2012-07-12

打赏
举报

INSERT INTO JU_People_Record(yszc,id_rl) values(赋值变量,赋值变量)
[Quote=引用 2 楼的回复:]
引用 1 楼的回复:
SQL code
CREATE TRIGGER [JU_Uint_People_XueliAndZhichengUpdate] ON [dbo].[JU_Unit_People]
FOR UPDATE
AS
IF UPDATE(xueli)
begin
INSERT INTO JU_People_Record(ysxl,id_rl) select xueli,……
[/Quote]

rkjk123456 2012-07-12

打赏
举报

[Quote=引用 1 楼的回复:]
SQL code
CREATE TRIGGER [JU_Uint_People_XueliAndZhichengUpdate] ON [dbo].[JU_Unit_People]
FOR UPDATE
AS
IF UPDATE(xueli)
begin
INSERT INTO JU_People_Record(ysxl,id_rl) select xueli,id_rl f……
[/Quote]
能说下为什么要这么用才可以么

xuam 2012-07-12

打赏
举报

CREATE TRIGGER [JU_Uint_People_XueliAndZhichengUpdate] ON [dbo].[JU_Unit_People]   

FOR UPDATE   

AS

IF UPDATE(xueli)

begin

INSERT INTO JU_People_Record(ysxl,id_rl) select xueli,id_rl from Deleted

end

IF UPDATE(ZhiCheng)

begin

INSERT INTO JU_People_Record(yszc,id_rl) select ZhiCheng,id_rl from Deleted

end