Вообщем получаю такую ошибку
| Цитата |
| a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. |
| Цитата |
| несовпадение числа начинаются и принятия операторов. Предыдущее количество = 1, текущее количество = 0. |
begin try
alter procedure....
params...
begin catch
set @Error_Code = error_number()
set @Error_Message = error_message()
if @@trancount>0
rollback
end catch
params...
end try
ALTER procedure [r2].[p_ListProcedure]
(
@Param bigint,
@Error_Code int = null output,
@Error_Message varchar(4000) = null output
)
as
set nocount on
begin try
Declare bla bla bla
begin catch
set @Error_Code = error_number()
set @Error_Message = error_message()
if @@trancount>0
rollback
end catch
| Цитата |
| Syntax BEGIN TRY { sql_statement | statement_block } END TRY BEGIN CATCH [ { sql_statement | statement_block } ] END CATCH [ ; ] |
ALTER procedure [r2].[p_ListProcedure]
(
@Param bigint,
@Error_Code int = null output,
@Error_Message varchar(4000) = null output
)
as
set nocount on
begin try
Declare bla bla bla
end try
begin catch
set @Error_Code = error_number()
set @Error_Message = error_message()
if @@trancount>0
rollback
end catch
begin tran my_transaction
......
commit tran my_transaction