DP44/DataPRO_sql/dbo.sp_SensorsAnalogUpdate.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_SensorsAnalogUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_SensorsAnalogUpdate]
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_SensorsAnalogUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_SensorsAnalogUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_SensorsAnalogUpdate]
			@SerialNumber				nvarchar(50) = null
           ,@UserSerialNumber			nvarchar(50)
           ,@Model						nvarchar(50)
           ,@Manufacturer				nvarchar(50)
           ,@Status						nvarchar(50)
           ,@MeasurementUnit			nvarchar(50)
           ,@OffsetToleranceLow			float
           ,@OffsetToleranceHigh		float
           ,@eId						nvarchar(50)
           ,@Capacity					float
           ,@Comment					nvarchar(255)
           ,@BridgeType					smallint
           ,@BridgeLegMode				smallint
           ,@Shunt						smallint
           ,@Invert						bit
           ,@UserValue1					nvarchar(50)
           ,@UserValue2					nvarchar(50)
           ,@UserValue3					nvarchar(50)
           ,@FilterClass				nvarchar(50)
           ,@BridgeResistance			float
           ,@IsoCode					nvarchar(50)
           ,@CheckOffset				bit
           ,@SupportedExcitation		nvarchar(50)
           ,@CalInterval				int
           ,@CalibrationSignal			bit
           ,@InternalShuntResistance	float
           ,@ExternalShuntResistance	float
           ,@UniPolar					bit
           ,@RangeLow					float
           ,@RangeAve					float
           ,@RangeHigh					float
           ,@Created					datetime
           ,@TimesUsed					bigint
           ,@SensorCategory				int
           ,@BypassFilter				bit
           ,@CouplingMode				smallint
           ,@Version					int
           ,@LastModified				datetime
           ,@ModifiedBy					nvarchar(50)
           ,@LocalOnly					bit
           ,@AxisNumber					smallint
           ,@NumberOfAxes				smallint
           ,@UserTags					varbinary(max)
           ,@DoNotUse					bit
           ,@Broken						bit
		   ,@errorNumber				int				output
		   ,@errorMessage				nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)

	if(@SerialNumber is null)
	begin 
		RAISERROR(15600,-1,-1, 'sp_SensorsAnalogUpdate') /* Error 1560 - An invalid parameter or option was specified for procedure*/
	end
	else
	begin				
		SET NOCOUNT ON;
		UPDATE [dbo].[SensorsAnalog]
			   SET [UserSerialNumber] 			=@UserSerialNumber		
				  ,[Model] 						=@Model					
				  ,[Manufacturer] 				=@Manufacturer			
				  ,[Status] 					=@Status					
				  ,[MeasurementUnit] 			=@MeasurementUnit		
				  ,[OffsetToleranceLow] 		=@OffsetToleranceLow		
				  ,[OffsetToleranceHigh] 		=@OffsetToleranceHigh	
				  ,[eId] 						=@eId						
				  ,[Capacity] 					=@Capacity				
				  ,[Comment] 					=@Comment				
				  ,[BridgeType] 				=@BridgeType				
				  ,[BridgeLegMode] 				=@BridgeLegMode			
				  ,[Shunt] 						=@Shunt					
				  ,[Invert] 					=@Invert					
				  ,[UserValue1] 				=@UserValue1				
				  ,[UserValue2] 				=@UserValue2				
				  ,[UserValue3] 				=@UserValue3				
				  ,[FilterClass] 				=@FilterClass			
				  ,[BridgeResistance] 			=@BridgeResistance		
				  ,[IsoCode] 					=@IsoCode				
				  ,[CheckOffset] 				=@CheckOffset			
				  ,[SupportedExcitation] 		=@SupportedExcitation	
				  ,[CalInterval] 				=@CalInterval			
				  ,[CalibrationSignal] 			=@CalibrationSignal		
				  ,[InternalShuntResistance] 	=@InternalShuntResistance
				  ,[ExternalShuntResistance] 	=@ExternalShuntResistance
				  ,[UniPolar] 					=@UniPolar				
				  ,[RangeLow] 					=@RangeLow				
				  ,[RangeAve] 					=@RangeAve				
				  ,[RangeHigh] 					=@RangeHigh				
				  ,[Created] 					=@Created				
				  ,[TimesUsed] 					=@TimesUsed				
				  ,[SensorCategory] 			=@SensorCategory			
				  ,[BypassFilter] 				=@BypassFilter			
				  ,[CouplingMode] 				=@CouplingMode			
				  ,[Version] 					=@Version				
				  ,[LastModified] 				=@LastModified			
				  ,[ModifiedBy] 				=@ModifiedBy				
				  ,[LocalOnly] 					=@LocalOnly				
				  ,[AxisNumber] 				=@AxisNumber				
				  ,[NumberOfAxes] 				=@NumberOfAxes			
				  ,[UserTags] 					=@UserTags				
				  ,[DoNotUse] 					=@DoNotUse				
				  ,[Broken] 					=@Broken					
			 WHERE [SerialNumber] 				=@SerialNumber	
	end
END




























GO