CREATE PROCEDURE [dbo].[sp_ROIPeriodChannelsInsert_98] @TestSetupROIId int ,@ChannelName nvarchar(4000) ,@ChannelId bigint ,@errorNumber int output ,@errorMessage nvarchar(250) output AS BEGIN set @errorNumber = 0 set @errorMessage = space(0) SET NOCOUNT ON; IF (@TestSetupROIId IS NULL) BEGIN SET @errorNumber = 1 SET @errorMessage = 'must contain a test setup id or a test setup name' return END INSERT INTO [dbo].[ROIPeriodChannels] ([TestSetupROIId], [ChannelName], [ChannelId]) values (@TestSetupROIId, @ChannelName, @ChannelId) if(@@error != 0) begin set @errorNumber = error_number() set @errorMessage = error_message() end end