Stored Procedures [dbo].[GetOneConfigurationInfo]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Namenvarchar(260)520
Permissions
TypeActionOwning Principal
GrantExecuteRSExecRole
SQL Script
CREATE PROCEDURE [dbo].[GetOneConfigurationInfo]
@Name nvarchar (260)
AS
SELECT [Value]
FROM [ConfigurationInfo]
WHERE [Name] = @Name

GO
GRANT EXECUTE ON  [dbo].[GetOneConfigurationInfo] TO [RSExecRole]
GO
Uses