150 lines
9.1 KiB
Transact-SQL
150 lines
9.1 KiB
Transact-SQL
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
|