Skip to content

Step documentation for DatabaseFunction

Execute database function

Execute a table valued database function without parameters

Sentences

Type Language Sentence
When en I execute the [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] function
When nl ik de functie [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] uitvoer

Arguments

Parameter Datatype Description
schemaName String The schema owning the function
functionName String Then name of the function

Examples

When I execute the [sys].[fn_servershareddrives] function
Als ik de functie [sys].[fn_servershareddrives] uitvoer

Execute database function with parameters

Execute a table valued database function with parameters

Sentences

Type Language Sentence
When en I execute the [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] function with the following parameters?:
When nl ik de functie [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] uitvoer met de volgende parameters?:

Arguments

Parameter Datatype Description
schemaName String The schema owning the function
functionName String Then name of the function
Table Table A table with the function parameter(s), structured as | Parameter | Value |. See ParameterTable.

Examples

When I execute the [sys].[dm_os_file_exists] function with the following parameters:
    | Parameter         | Value                 |
    | file_or_directory | 'C:\\Not_a_real_file' |
Als ik de functie [sys].[dm_os_file_exists] uitvoer met de volgende parameters:
    | Parameter         | Value                 |
    | file_or_directory | 'C:\\Not_a_real_file' |

Execute conventioned function

Execute a table valued database function using a convention

Sentences

Type Language Sentence
When en I execute the ([a-zA-Z0-9_@$#]+) ([a-zA-Z0-9_-]+) function
When en ik de ([a-zA-Z0-9_@$#]+) ([a-zA-Z0-9_-]+) functie uitvoer

Arguments

Parameter Datatype Description
functionName String Then name of the function
namingConventionName String Then convention name of the function

Examples

When I execute the fn_servershareddrives sys function
Als ik de fn_servershareddrives sys functie uitvoer

Execute conventioned function with parameters

Execute a table valued database function using a convention and with parameters

Sentences

Type Language Sentence
When en I execute the ([a-zA-Z0-9_@$#]+) ([a-zA-Z0-9_-]+) function with the following parameters?:
When en ik de ([a-zA-Z0-9_@$#]+) ([a-zA-Z0-9_-]+) functie uitvoer met de volgende parameters?:

Arguments

Parameter Datatype Description
functionName String Then name of the function
namingConventionName String Then convention name of the function
Table Table A table with the function parameter(s), structured as | Parameter | Value |. See ParameterTable.

Examples

When I execute the dm_os_file_exists sys function with the following parameter:
    | Parameter         | Value                 |
    | file_or_directory | 'C:\\Not_a_real_file' |
Als ik de dm_os_file_exists sys functie uitvoer met de volgende parameter:
    | Parameter         | Value                 |
    | file_or_directory | 'C:\\Not_a_real_file' |