INSERT INTO [dbo].[Sensors] ([SensorType],[SerialNumber]) VALUES (1, 'TSI_TestSpecific'); DECLARE @SensorId int SET @SensorId = CAST(SCOPE_IDENTITY() as int); INSERT INTO [dbo].[SensorsDigitalIn] ([SensorId] ,[SettingMode] ,[ScaleMultiplier] ,[LastModified] ,[LastModifiedBy] ,[eId] ,[IsoCode] ,[IsoChannelName] ,[UserCode] ,[UserChannelName] ,[UserValue1] ,[UserValue2] ,[UserValue3] ,[UserTags] ,[MeasurementUnit] ,[FilterClass] ,[DoNotUse] ,[Broken]) VALUES (@SensorId, 8, 'ArbitraryLowAndHigh,0,1', '2019-06-11 12:00:00.000', 'SYSTEM', '', '', '', '', '', '', '', '', 0, 'V', 'Unfiltered', 0, 0);