Step documentation for Function
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 |
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 |
schema name |
string |
The schema owning the function |
function name |
string |
The name of the function |
Examples
When I execute the [sys].[fn_servershareddrives] function
Als ik de functie [sys].[fn_servershareddrives] uitvoer
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?: |
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 |
schema name |
string |
The schema owning the function |
function name |
string |
The name of the function |
parameter 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' |
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 templated function
Execute a table valued database function using an object template
Sentences
Type |
Language |
Sentence |
When |
en |
I execute the ([a-zA-Z0-9_@$#]+) ([a-zA-Z0-9_@$#-]+) function |
When |
nl |
ik de ([a-zA-Z0-9_@$#]+) ([a-zA-Z0-9_@$#-]+) functie uitvoer |
Arguments
Parameter |
Datatype |
Description |
function name |
string |
Then name of the function |
object template name |
string |
The object template name for the function |
Examples
When I execute the fn_servershareddrives sys function
Als ik de fn_servershareddrives sys functie uitvoer
Execute templated function with parameters
Execute a table valued database function using an object template 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 |
nl |
ik de ([a-zA-Z0-9_@$#]+) ([a-zA-Z0-9_@$#-]+) functie uitvoer met de volgende parameters?: |
Arguments
Parameter |
Datatype |
Description |
function name |
string |
The name of the function |
object template name |
string |
The object template name for the function. |
parameter 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' |