30 lines
1.1 KiB
Plaintext
30 lines
1.1 KiB
Plaintext
|
ALTER PROCEDURE [dbo].[sp_SensorsStreamOutputUpdate]
|
||
|
|
@Id INT,
|
||
|
|
|
||
|
|
@StreamProfile NVARCHAR (50),
|
||
|
|
@UDPAddress NVARCHAR (50),
|
||
|
|
@TimeChannelId INT,
|
||
|
|
@DataChannelId INT,
|
||
|
|
@TmNSConfig NVARCHAR (50),
|
||
|
|
@IRIGTimeDataPacketIntervalMs INT,
|
||
|
|
|
||
|
|
@LastModified DATETIME,
|
||
|
|
@LastModifiedBy NVARCHAR (50),
|
||
|
|
@UserTags VARBINARY (MAX),
|
||
|
|
@Broken BIT,
|
||
|
|
@DoNotUse BIT,
|
||
|
|
@errorNumber INT OUTPUT,
|
||
|
|
@errorMessage NVARCHAR (255) OUTPUT
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
SET @errorNumber = 0
|
||
|
|
SET @errorMessage = ''
|
||
|
|
|
||
|
|
UPDATE [dbo].SensorsStreamOutput SET [StreamProfile]=(CASE WHEN @StreamProfile='UART_STREAM' THEN 'CH10_ANALOG_2HDR' ELSE @StreamProfile END), [UDPAddress]=@UDPAddress, [TimeChannelId]=@TimeChannelId, [DataChannelId]=@DataChannelId, [TmNSConfig]=@TmNSConfig, [IRIGTimeDataPacketIntervalMs]=@IRIGTimeDataPacketIntervalMs, [LastModified]=@LastModified, [LastModifiedBy]=@LastModifiedBy, [UserTags]=@UserTags, [Broken]=@Broken, [DoNotUse]=@DoNotUse WHERE [SensorId] = @Id
|
||
|
|
|
||
|
|
IF(@@error != 0)
|
||
|
|
BEGIN
|
||
|
|
SET @errorNumber = error_number()
|
||
|
|
SET @errorMessage = error_message()
|
||
|
|
END
|
||
|
|
END
|