DP44/DataPRO_sql/dbo.sp_CalculatedChannelsUpdate.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_CalculatedChannelsUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_CalculatedChannelsUpdate]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_CalculatedChannelsUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_CalculatedChannelsUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_CalculatedChannelsUpdate]
		 @id						 int	= 0
		,@Operation					 int
		,@CalculatedChannelValueCode nvarchar(255)
		,@InputChannelIds			 varbinary(max)
		,@CFCForInputChannels		 nvarchar(255)
		,@CFCForOutput				 nvarchar(255)
		,@TestSetupName				 nvarchar(255) = null
		,@CCName					 nvarchar(255)
		,@errorNumber			int				output
		,@errorMessage			nvarchar(250)	output 
AS
BEGIN
		SET NOCOUNT ON;
	set @errorNumber = 0 
	set @errorMessage = space(0)

	if(@id = 0 or @Operation is null or @TestSetupName is null)
	begin 
		RAISERROR(15600,-1,-1, 'sp_CalculatedChannelsUpdate') /* Error 1560 - An invalid parameter or option was specified for procedure*/
	end
	else
	begin
		UPDATE [dbo].[CalculatedChannels]
		   SET [Operation]					= @Operation		
			  ,[CalculatedChannelValueCode] = @CalculatedChannelValueCode
			  ,[InputChannelIds]			= @InputChannelIds			
			  ,[CFCForInputChannels]		= @CFCForInputChannels		
			  ,[CFCForOutput]				= @CFCForOutput				
			  ,[CCName]						= @CCName					
		 WHERE [Id]							= @id
	end
END































GO