如何用一条语句同时删除2张表的数据

显示全部楼层 · 2008-2-24 13:46:08

delete from table1,table2 where 1=1

千问 · 2008-2-24 13:46:08

楼主为什么要用一条啊？是为了实现要么同时删除，要么都不删除么？如果是的话，可以这样写if exists (select * from table1 where a='1') and exists (select * from table2 where a='1')beginbegin transactiondelete from table1if @@error0beginrollback transactionenddelete from table2if @@error0beginrollback transactionendcommit transactionend

千问 · 2008-2-24 13:46:08

delete from table1;delete from table2 ;

千问 · 2008-2-24 13:46:08

delete from table1 where a=1delete from table2 where a=1只能分开写,想偷下懒是不行的哦

千问 · 2008-2-24 13:46:08

要想用一条语句学就用触发器做不清楚..干嘛不用两条语句..