在次提问

[邦迪代驾]

二个不同数据库的表，当一个表删除一条记录的时候，别外一个表也要删除相应的记录，请问这种怎么实现呀，触发器可以吗，应该怎么去写呢？

[chenjunjarysky]

create trigger u_aa on DB1..talA
for delete
as
begin
delete from DB2..talB
where DB2..talB.*=deleted.*

end

[marco08]

触发器可以
如果两表有主外键关联还可以用级联删除

[DengXingJie]

最好是建立關聯
就像父表與子表一樣

[myppfly]

沒聽過
學習

[Well]

用SQL语句进行删除
delete from tableName1 where col1=1
delete from tableName2 where col1=1

[xiaoku]

同一个服务器就使用触发器吧!

[xiaoku]

具体你可以查看一下帮助:

CREATE TRIGGER
创建触发器，触发器是一种特殊的存储过程，在用户试图对指定的表执行指定的数据修改语句时自动执行。Microsoft® SQL Server™ 允许为任何给定的 INSERT、UPDATE 或 DELETE 语句创建多个触发器。

语法
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS
[ { IF UPDATE ( column )
[ { AND | OR } UPDATE ( column ) ]
[ ...n ]
| IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask )
{ comparison_operator } column_bitmask [ ...n ]
} ]
sql_statement [ ...n ]
}
}

[xiaoku]

create trigger u_aa on talA
for delete
as
begin
--select * from deleted 这里面放的是你删除的数据
delete from 另一个数据库..talA
where ...

end