哦上面写错了,应该是
CREATE TRIGGER [tri_cpxmdel] ON dbo.t_cpxm
FOR DELETE
AS
declare @cpid char
select @cpid=cpid from inserted
delete from t_jinhuo where cpid=@cpid 如何改啊?
CREATE TRIGGER [tri_cpxmdel] ON dbo.t_cpxm
FOR DELETE
AS
declare @cpid char
select @cpid=cpid from inserted
delete from t_jinhuo where cpid=@cpid 如何改啊?
在关系图设置了关系,除非把关系删掉,否则无法删除!要么要先删有此表相关的数据行然而删除此表
create table t_cpxm (cpid varchar(100) not null primary key )
create table t_jinhuo
(cpid varchar(100) EFERENCES _cpxm (cpid ) ON DELETE CASCADE ON UPDATE CASCADE )
CREATE TRIGGER 名2 ON dbo.t_cpxm
FOR update
AS
update t_jinhuo
set 列=aa.列
from inserted aa where aa.编号=t_jinhuo .编号
FOR DELETE
AS
delete t_jinhuo from inserted where t_jinhuo.cpid=inserted.cpid
这句,当删除不是一条记录时,出错!