CREATE TRIGGER 名1 ON tab_pritest
FOR INSERT
AS
insert tab_slatest select * from insertedCREATE TRIGGER 名2 ON tab_pritest
FOR update
AS
update tab_slatest set 列=aa.列 from inserted aa where aa.i_no=tab_slatest.i_no
CREATE TRIGGER 名3 ON tab_pritest
FOR delete
AS
delete tab_slatest where i_no in (select i_no from deleted)
FOR INSERT
AS
insert tab_slatest select * from insertedCREATE TRIGGER 名2 ON tab_pritest
FOR update
AS
update tab_slatest set 列=aa.列 from inserted aa where aa.i_no=tab_slatest.i_no
CREATE TRIGGER 名3 ON tab_pritest
FOR delete
AS
delete tab_slatest where i_no in (select i_no from deleted)
解决方案 »
- 【All】求SQL,请大家帮忙。。。。。。。。。。。。。。。。。。。。。。。。。
- 请教一个小小的数据库设计,各位来看看图
- 弱问:“每天的12:00 am和5:00 pm对northwind进行日志备份” 怎样才能实现?
- 高人请帮忙给一个关于栏目列表查询的SQL语句。
- 我始终不太明白领域模式,领域对象,事务处理模式,表模式这些概念,望专家咨询
- 请教一嵌套查询SQL语句
- 邹建大哥帮看看,求语句?
- SQL老发生死锁,请高手帮忙!!
- 在sql server的表中可以无限制的输入文本吗
- 我在用VB做数据库,需要同时在本地和远程(SQL SERVER)对数据进行操作,如果远程网络不同时,我要实现本地操作,应该怎样使用断开远程的
- BCP使用問題
- 我的sqlserver服务器如何用dsn连接?
CREATE TRIGGER 名 on tab_slatest
INSTEAD OF INSERT
AS
BEGIN
insert tab_pritest select * from inserted
insert tab_slatest select * from inserted
END主表记录删除时自动删除子表记录
CREATE TRIGGER 名 on tab_pritest
INSTEAD OF delete
AS
BEGIN
delete tab_slatest where i_no in (select i_no from deleted)
delete tab_pritest where i_no in (select i_no from deleted)
END
on tab_pritest
for delete
as delete tab_slatest where i_no=1
return
最好完一致(相互对应的一样)当子表增加记录时,由插入动力引起触发器,
CREATE TRIGGER tab_slatest_tri on tab_slatest
for INSERT
AS
insert tab_pritest select * from inserted,tab_slatest
where tab_slatest.i_no=inserted.i_no主表记录删除时引起触发器自动删除子表记录
CREATE TRIGGER tab_pritest_tri on tab_pritest
for delete
AS
delete tab_slatest where i_no from tab_pritest,deleted
where tab_pritest.i_no=deleted.i_no
就把每个表的路径写完整
如
pubs.dbo.tab_pritest
FOR INSERT
AS
insert tab_pritest(c_aa,c_bb) select c_dd,f_num from inserted CREATE TRIGGER 名3 ON tab_pritest
FOR delete
AS
delete t1 from tab_slatest t1,deleted t2 where t1.i_no=t2.i_no
用级联删除
create table tab_pritest --主表
( i_no int identity(1,1) not null PRIMARY KEY CLUSTERED ,
c_aa varchar(10),
c_bb varchar(10)
)create table tab_slatest --子表
( i_no int REFERENCES tab_pritest (i_no) ON DELETE CASCADE ON UPDATE CASCADE ,
c_dd varchar(10),
f_num varchar(10)
)
kfcn:删除主表记录时出现错误“对象名tab_Pritest.delete无效”把每个表的路径写完整也出现这样的错误。插入记录时也出现这样的错误