Files

24 lines
1.8 KiB
MySQL
Raw Permalink Normal View History

2026-04-17 14:55:32 -04:00
<EFBFBD><EFBFBD>ALTER PROCEDURE [dbo].[sp_TemplateChannelsDeleteOne]
@TemplateChannelId int = 0
,@errorNumber int output
,@errorMessage nvarchar(250) output
AS
BEGIN
set @errorMessage = space(0); set @errorNumber = 0;
begin try
begin transaction tDeleteTemplateChannel
declare @ChannelName nvarchar(100)
declare @MMEChannelId bigint
select @ChannelName = NameOfTheChannel, @MMEChannelId = MMEChannelId from [dbo].[TemplateChannels] where [TemplateChannelId] = @TemplateChannelId
delete from [dbo].[TestChannelSettings] where [TemplateChannelId] = @TemplateChannelId
delete from [dbo].[TemplateChannels] WHERE [TemplateChannelId] = @TemplateChannelId
commit transaction tDeleteTemplateChannel
end try
begin catch
set @errorMessage = error_message()
set @errorNumber = error_number()
rollback transaction tDeleteTemplateChannel
end catch;
END