DP44/DataPRO_sql/dbo.sp_SensorModelsUpdate.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_SensorModelsUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_SensorModelsUpdate]
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_SensorModelsUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_SensorModelsUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_SensorModelsUpdate]
			@Model					nvarchar(50)
           ,@Manufacturer			nvarchar(50)
           ,@UserPartNumber			nvarchar(50)
           ,@Capacity				float
           ,@OffsetToleranceLow		float
           ,@OffsetToleranceHigh	float
           ,@MeasurementUnit		nvarchar(50)
           ,@Bridge					smallint
           ,@Shunt					smallint
           ,@BridgeResistance		float
           ,@FilterClass			nvarchar(50)
           ,@UniPolar				bit
           ,@IgnoreRange			bit
           ,@CouplingMode			smallint
           ,@Version				int
           ,@RangeLow				float
           ,@RangeAve				float
           ,@RangeHigh				float
           ,@LastModified			datetime
           ,@ModifiedBy				nvarchar(50)
           ,@LocalOnly				bit
           ,@NumberOfAxes			smallint
           ,@CalInterval			int
           ,@AxisNumber				smallint
           ,@Polarity				nvarchar(10)
           ,@Invert					bit
           ,@CheckOffset			bit
           ,@CalibrationRecord		nvarchar(255)
           ,@ISOCode				nvarchar(20)
           ,@SupportedExcitation	nvarchar(255)
		   ,@InitialEU				float
		   ,@errorNumber			int				output
		   ,@errorMessage			nvarchar(250)	output
AS
BEGIN

	set @errorNumber = 0 
	set @errorMessage = space(0)
	UPDATE [dbo].[SensorModels]
	   SET [Model]					= @Model				
		  ,[Manufacturer]			= @Manufacturer		
		  ,[UserPartNumber]			= @UserPartNumber		
		  ,[Capacity]				= @Capacity			
		  ,[OffsetToleranceLow]		= @OffsetToleranceLow	
		  ,[OffsetToleranceHigh]	= @OffsetToleranceHigh
		  ,[MeasurementUnit]		= @MeasurementUnit	
		  ,[Bridge]					= @Bridge				
		  ,[Shunt]					= @Shunt				
		  ,[BridgeResistance]		= @BridgeResistance	
		  ,[FilterClass]			= @FilterClass		
		  ,[UniPolar]				= @UniPolar			
		  ,[IgnoreRange]			= @IgnoreRange		
		  ,[CouplingMode]			= @CouplingMode		
		  ,[Version]				= @Version			
		  ,[RangeLow]				= @RangeLow			
		  ,[RangeAve]				= @RangeAve			
		  ,[RangeHigh]				= @RangeHigh			
		  ,[LastModified]			= @LastModified		
		  ,[ModifiedBy]				= @ModifiedBy			
		  ,[LocalOnly]				= @LocalOnly			
		  ,[NumberOfAxes]			= @NumberOfAxes		
		  ,[CalInterval]			= @CalInterval		
		  ,[AxisNumber]				= @AxisNumber			
		  ,[Polarity]				= @Polarity			
		  ,[Invert]					= @Invert				
		  ,[CheckOffset]			= @CheckOffset		
		  ,[CalibrationRecord]		= @CalibrationRecord	
		  ,[ISOCode]				= @ISOCode			
		  ,[SupportedExcitation]	= @SupportedExcitation
		  ,[InitialEU]				= @InitialEU
	 WHERE [Model]					= @Model
	 and   [Manufacturer]			= @Manufacturer
 		
END




























GO