71 lines
1.6 KiB
Transact-SQL
71 lines
1.6 KiB
Transact-SQL
USE [DataPRO]
|
||
GO
|
||
/****** Object: StoredProcedure [dbo].[sp_SensorsDigitalInGet] Script Date: 6/19/2018 12:24:43 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
ALTER PROCEDURE [dbo].[sp_SensorsDigitalInGet]
|
||
@SerialNumber nvarchar(50) = null,
|
||
@Id nvarchar(50) = null
|
||
AS
|
||
BEGIN
|
||
SET NOCOUNT ON;
|
||
|
||
SELECT [SerialNumber] as 'SettingName'
|
||
,[SettingMode]
|
||
,[ScaleMultiplier]
|
||
,[LastModified]
|
||
,[LastModifiedBy]
|
||
,[eId]
|
||
,[UserValue1]
|
||
,[UserValue2]
|
||
,[UserValue3]
|
||
,[UserTags]
|
||
,[MeasurementUnit]
|
||
,[FilterClass]
|
||
FROM [dbo].[SensorsDigitalIn] where (@SerialNumber is null or SerialNumber = @SerialNumber ) AND (@Id is null or eId = @Id)
|
||
END
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|