Skip to content

CrossTest v1.0

Function

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' |