DP44/DataPRO_sql/.svn/pristine/61/6122b4df9ac38821622a079bd99309a5c6327718.svn-base

<EFBFBD><EFBFBD>USE [DataPRO]
GO
/****** Object:  StoredProcedure [dbo].[sp_SensorsDigitalInUpdate]    Script Date: 6/19/2018 12:30:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_SensorsDigitalInUpdate]
		 @SerialNumber		nvarchar(50)
		,@SettingMode		int
		,@ScaleMultiplier	nvarchar(50)
		,@LastModified		datetime
		,@LastModifiedBy	nvarchar(50)
		,@eId				nvarchar(50)
		,@UserValue1		nvarchar(255)
		,@UserValue2		nvarchar(255)
		,@UserValue3		nvarchar(255)
		,@UserTags			varbinary(max)
		,@MeasurementUnit	nvarchar(50)
		,@FilterClass		nvarchar(50)
		,@errorNumber		int				output
		,@errorMessage		nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)


UPDATE [dbo].[SensorsDigitalIn]
   SET [SettingMode]		= @SettingMode		
      ,[ScaleMultiplier]	= @ScaleMultiplier	
      ,[LastModified]		= @LastModified		
      ,[LastModifiedBy]		= @LastModifiedBy	
      ,[eId]				= @eId			
      ,[UserValue1]			= @UserValue1		
      ,[UserValue2]			= @UserValue2		
      ,[UserValue3]			= @UserValue3		
      ,[UserTags]			= @UserTags
	  ,[MeasurementUnit]	= @MeasurementUnit			
	  ,[FilterClass]		= @FilterClass			
 where SerialNumber = @SerialNumber
END