karshenasi
پنج شنبه 29 مهر 1389, 11:38 صبح
CREATE PROCEDURE DeleteQTransaction @QID int
AS
Declare @ss int,@rr int
Begin Transaction
delete from Question where QID=@QID
set @ss=@@Error
save Transaction ssaved
delete from answer where QID=@QID
set @rr=@@Error
if @rr<>0
RollBack Transaction ssaved
if(@ss=0 and @rr=0)
Commit Transaction
Else
RollBack Transaction
RETURN
AS
Declare @ss int,@rr int
Begin Transaction
delete from Question where QID=@QID
set @ss=@@Error
save Transaction ssaved
delete from answer where QID=@QID
set @rr=@@Error
if @rr<>0
RollBack Transaction ssaved
if(@ss=0 and @rr=0)
Commit Transaction
Else
RollBack Transaction
RETURN