8 lines
366 B
Plaintext
8 lines
366 B
Plaintext
INSERT INTO [dbo].[Sensors]([SensorType], [SerialNumber])
|
|
VALUES(6, 'TSN_TestSpecific');
|
|
|
|
DECLARE @sensorID int;
|
|
SET @sensorID = CAST(SCOPE_IDENTITY() as int);
|
|
|
|
INSERT INTO [dbo].[SensorsStreamInput] ([SensorId], [UDPAddress], [LastModified], [LastModifiedBy], [UserTags])
|
|
VALUES(@sensorID, 'UDP://239.1.2.10:8400', '2018-12-18 12:00:00.000', 'SYSTEM', 0); |