ROLLBACK TRANSACTION 请求没有对应的 BEGIN TRANSACTION

[glassy2000]

这是我的存储过程，编译通过：
ALTER PROCEDURE [dbo].[st_dele_whole_sales]
@id int,
@execute int output
AS
BEGIN
begin transaction
begin try
update tb_sales set active='L' where id=@id
set @execute=1

commit transaction
end try
begin catch
set @execute=0
rollback transaction
end catch
END

但执行时却出错:
st_dele_whole_sales 13194,-1

错误提示:
消息 3903，级别 16，状态 1，过程 st_dele_whole_sales，第 21 行
ROLLBACK TRANSACTION 请求没有对应的 BEGIN TRANSACTION。

没发现语句有错呀，是哪不对呀，请大家指教！！

[SQLCenter]

ALTER PROCEDURE [dbo].[st_dele_whole_sales] 
@id int,
@execute int output
AS
BEGIN
begin try
	begin transaction
	update tb_sales set active='L' where id=@id
	set @execute=1
	commit transaction
end try
begin catch
	set @execute=0
	rollback transaction
end catch
END

[abuying]

ALTER PROCEDURE [dbo].[st_dele_whole_sales]
@id int,
@execute int output
AS
BEGIN

begin transaction
update tb_sales set active='L' where id=@id
set @execute=1
begin try --把transaction提前到try前
commit transaction
end try
begin catch
set @execute=0
rollback transaction
end catch
END

[颠簸在路上]

commit transaction 已经提交了上面的transaction
下面的 rollback transaction 已经没有事务回滚了