43 lines
1.5 KiB
Plaintext
43 lines
1.5 KiB
Plaintext
|
|
CREATE PROCEDURE [dbo].[sp_SensorsStreamOutputInsert]
|
|
@SerialNumber NVARCHAR (50),
|
|
|
|
@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,
|
|
@new_id INT OUTPUT,
|
|
@errorNumber INT OUTPUT,
|
|
@errorMessage NVARCHAR (255) OUTPUT
|
|
AS
|
|
BEGIN
|
|
SET @errorNumber = 0
|
|
SET @errorMessage = space(0)
|
|
|
|
DECLARE @SensorId AS INT
|
|
DECLARE @SensorType AS TINYINT
|
|
|
|
SELECT @SensorType = [TypeId] FROM [dbo].[SensorsType] WHERE [SensorType]='StreamOutput'
|
|
|
|
INSERT INTO [dbo].[Sensors] ([SensorType], [SerialNumber]) VALUES (@SensorType, @SerialNumber)
|
|
|
|
SELECT @SensorId = SCOPE_IDENTITY()
|
|
|
|
INSERT INTO [dbo].[SensorsStreamOutput] ([SensorId], [StreamProfile], [UDPAddress], [TimeChannelId], [DataChannelId], [TmNSConfig], [IRIGTimeDataPacketIntervalMs], [LastModified], [LastModifiedBy], [UserTags], [Broken], [DoNotUse]) VALUES (@SensorId, @StreamProfile, @UDPAddress, @TimeChannelId, @DataChannelId, @TmNSConfig, @IRIGTimeDataPacketIntervalMs, @LastModified, @LastModifiedBy, @UserTags, @Broken, @DoNotUse)
|
|
|
|
IF(@@error != 0)
|
|
BEGIN
|
|
SET @errorNumber = error_number()
|
|
SET @errorMessage = error_message()
|
|
END
|
|
SET @new_id = @SensorId
|
|
|
|
END |