CREATE TRIGGER trigger_update_表1 ON 表1
FOR UPDATE AS
BEGIN
if exists(select * from sysobjects where name = '表2')
begin
insert into 表2(pz) select pz from inserted
end
END CREATE TRIGGER trigger_insert_表1 ON 表1
FOR INSERT AS
BEGIN
if exists(select * from sysobjects where name = '表2')
begin
insert into 表2(pz) select pz from inserted
end
END ========================
大概是这样的语法,没有验证过。
FOR UPDATE AS
BEGIN
if exists(select * from sysobjects where name = '表2')
begin
insert into 表2(pz) select pz from inserted
end
END CREATE TRIGGER trigger_insert_表1 ON 表1
FOR INSERT AS
BEGIN
if exists(select * from sysobjects where name = '表2')
begin
insert into 表2(pz) select pz from inserted
end
END ========================
大概是这样的语法,没有验证过。
解决方案 »
- TTreeView 的背景图片怎么弄啊。
- 关于delphi fastreport不同打印格式的选择
- 请问如何去掉checkbox上面选中后的虚线框?
- 高手进来看看,delphi7+ado+mysql的问题
- CreateBitmap到底怎么用啊,大家帮我看看这段代码错在哪里?(100分)
- 怎么样用dephi设置word为只读不能对文档内容进行删除与修改(急急)
- 相恋五年的女友和我分手,我来散分!
- POST时如何得到各种错误信息
- 还在坚持的兄弟们,新年快乐!!!!!!!发分
- 怎样读取.MB(字码表)文件?
- 大家怎么看托普的招聘??
- 100分求助!!!!!如何在系统的右键菜单上添加菜单及子菜单并获得这个菜单的名柄
create trigger trigger_delete on a
for delete as
begin
'加入语句'
end
for delete as
begin
declare @aaa varchar(10);
select @aaa=aaa from table /*aaa为表中的字段*/
update table
end
INSTEAD OF INSERT as
begin
.
.
.
end