无意之中 实现了个两表互相调用插入触发器的代码
代码如下
create table A
(idint identity(1,1),Namevarchar(50))
create table B
(idint identity(1,1),Namevarchar(50))
go
CREATE TRIGGER ta1 ON A
FOR insert
AS
declare @Name varchar(50) ,@a int
select @Name=namefrom inserted
commit
BEGIN TRANSACTION
SELECT @a=count(name) FROM BWHERE name=@name
if(@a=0)begin
insert into B (Name) values (@Name)
end
go
CREATE TRIGGER ta2 ON B
FOR insert
AS
declare @Name varchar(50) ,@a int
select @Name=namefrom inserted
SELECT @a=count(name) FROM AWHERE name=@name
if(@a=0)
begin
insert into A(Name) values (@Name)
commit
BEGIN TRANSACTION
end
go
insert into A(name)values('2')
-
如不清楚请留言 或登录 http://www.lvtaostudio.com 查看和留言