How to delete records from 2 tables

[tgbnagaraj]

Hi

how to delete records which has same id from 2 tables.

In oracle

we can use

delete from t1,t2 where t1.id=1 and t1.id=t2.id

how to do this in sqlserver.

[dorinbogdan]

If want to delete records in 2 tables at the same time (with 1 statement) you must create a trigger like

if exists(select name from sysobjects where name = 'tg1' and type = 'TR')
drop trigger tg1
go
create trigger tg1 on t1 for Delete as
delete t2 from 
t2 inner join deleted on deleted.id=t2.id
go

Then, just delete the t1 record

delete from t1 where id = 1