ALTER PROCEDURE [dbo].[sp_SensorsAnalogUpdate] @Id INT, @UserSerialNumber NVARCHAR (50), @Model NVARCHAR (50), @SensorModelId INT, @Manufacturer NVARCHAR (50), @Status NVARCHAR (50), @MeasurementUnit NVARCHAR (50), @OffsetToleranceLow FLOAT, @OffsetToleranceHigh FLOAT, @eId NVARCHAR (50), @Capacity FLOAT, @Comment NVARCHAR (50), @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), @IsoChannelName NVARCHAR (255), @UserCode NVARCHAR (50), @UserChannelName NVARCHAR (255), @CheckOffset BIT, @SupportedExcitation NVARCHAR (50), @InitialEU FLOAT, @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, @DiagnosticsMode BIT, @FirstUseDate DATETIME NULL, @LatestCalibrationId INT NULL, @SerialNumber NVARCHAR (255), @ACCouplingModeEnabled BIT, @errorNumber INT OUTPUT, @errorMessage NVARCHAR (255) OUTPUT AS BEGIN SET NOCOUNT ON SET @errorNumber = 0 SET @errorMessage = '' UPDATE [dbo].[SensorsAnalog] SET [UserSerialNumber] = @UserSerialNumber, [Model] = @Model, [SensorModelId] = @SensorModelId, [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, [IsoChannelName] = @IsoChannelName, [UserCode] = @UserCode, [UserChannelName] = @UserChannelName, [CheckOffset] = @CheckOffset, [SupportedExcitation] = @SupportedExcitation, [InitialEU] = @InitialEU, [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, [DiagnosticsMode] = @DiagnosticsMode, [FirstUseDate] = @FirstUseDate, [LatestCalibrationId] = @LatestCalibrationId, [ACCouplingModeEnabled] = @ACCouplingModeEnabled WHERE [Id]=@Id if(@@error != 0) begin set @errorNumber = error_number() set @errorMessage = error_message() end END