config.ftv_get_parameter_value - IF

Description

Examples

Parameters

@Parameter_name (varchar(100))
@sub_Parameter (nvarchar(128))

Entity Diagram

Columns

Table 1. Columns of config.ftv_get_parameter_value - IF
Column Name	Data Type	NULL?
Parameter_value_result	`nvarchar(max)`	`NULL`
Parameter_value_result_date	`date`	`NULL`
Parameter_value_result_datetime	`datetime`	`NULL`
Parameter_value_result_int	`int`	`NULL`

References

Referenced Objects

config.Parameter - U

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

Parameter_value_result

nvarchar(max)

NULL

Parameter_value_result_date

date

NULL

Parameter_value_result_datetime

datetime

NULL

Parameter_value_result_int

int

NULL

sql_modules_definition

config.ftv_get_parameter_value - IF script

CREATE FUNCTION [config].[ftv_get_parameter_value]
(
    @Parameter_name Varchar(100)
  , @sub_Parameter  NVarchar(128) = N''
)
Returns Table
As
Return
(
    Select
        [Parameter_value_result]
		, [Parameter_value_result_int]
		, [Parameter_value_result_date]
		, [Parameter_value_result_datetime]
    From
        [config].Parameter
    Where
        Parameter_name    = @Parameter_name
        And sub_Parameter = @sub_Parameter
);