create proc procClass
@classid varchar(20)
as
begin tran
delete tb_Products where classid=@classid
if @@error<>0 goto err
delete tb_ProductClass where classid=@classid
if @@error<>0 goto err
[Quote=引用 4 楼 jwdream2008 的回复:]
SQL code
delete from tb_Products where classid in (select calssid from tb_ProductClass)
delete from tb_ProductClass
[/Quote]
我怎么样一起执行,谢谢