23 lines
934 B
Plaintext
23 lines
934 B
Plaintext
|
ALTER PROCEDURE [dbo].[sp_ChannelSettingsGet]
|
||
|
|
@Id int = NULL,
|
||
|
|
@SettingName NVARCHAR (255) = NULL
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
SET NOCOUNT ON;
|
||
|
|
IF (@Id IS NOT NULL) OR (@SettingName IS NOT NULL)
|
||
|
|
BEGIN
|
||
|
|
IF (@Id IS NULL)
|
||
|
|
BEGIN
|
||
|
|
SELECT [Id], [DefaultValue] FROM [dbo].[ChannelSettings] where (SettingName = @SettingName) AND (SettingName <> 'ACCouplingEnabled' AND SettingName <>'StreamOutTMATSIntervalMs')
|
||
|
|
END
|
||
|
|
ELSE
|
||
|
|
BEGIN
|
||
|
|
SELECT [SettingName] FROM [dbo].[ChannelSettings] where (Id = @Id) AND (SettingName <> 'ACCouplingEnabled' AND SettingName <>'StreamOutTMATSIntervalMs')
|
||
|
|
END
|
||
|
|
END
|
||
|
|
ELSE
|
||
|
|
BEGIN
|
||
|
|
SELECT [Id], [SettingName], [DefaultValue] FROM [dbo].[ChannelSettings] WHERE (SettingName <> 'ACCouplingEnabled' AND SettingName <>'StreamOutTMATSIntervalMs')
|
||
|
|
END
|
||
|
|
END
|