CREATE PROCEDURE shiwu AS
begin tran
update TNews set ftitle = '666' where fnewsid = 1
delete from TClass where fclassid = 4
if @@error <> 0
begin
rollback tran
return 0
end
else
begin
commit transaction
return 1
end
GO
=================================
delete语句,为有主外键关联所有删不掉...
如果去掉下划线的部分,就算出错,第一句更新也会执行.