create trigger del_
on tablea
for delete
as
begin
delete from tableb from tableb b,inserted d
where charindex(b.id,d.title) > 0
end
on tablea
for delete
as
begin
delete from tableb from tableb b,inserted d
where charindex(b.id,d.title) > 0
end
调试欢乐多
要是不是
create trigger del_
on tablea
for delete
as
begin
delete from tableb from tableb b,inserted d
where charindex(cast(b.id as varchar(10)),d.title) > 0
end
我觉得用charindex不妥,如果title值是‘123’,那tableb中的id是1的也会被删除