Metaflow - MSSQL

MSSQL

Metaflow referentie: MSSQL

Init

Optie	Waarde	Type veld
Host	The host of the database	tekst
User	The user of the database	tekst
Password	The password of the user of the database	tekst
Database name	The name of the database	tekst
Error	Error message, if action will fail	tekst

Init with intergrated security

Optie	Waarde	Type veld
Host	The host of the database	tekst
Database name	The name of the database	tekst
Error	Error message, if action will fail	tekst

Create connection

Optie	Waarde	Type veld
Error	Error message, if action will fail	tekst

Close connection

Optie	Waarde	Type veld
Error	Error message, if action will fail	tekst

Prepare SQL statement

Optie	Waarde	Type veld
SQL statement	The SQL statement to prepare	source
Error	Error message, if action will fail	tekst

Execute SQL statement

Optie	Waarde	Type veld
SQL statement	The SQL statement to execute	source
Error	Error message, if action will fail	tekst

Insert SQL statement

Optie	Waarde	Type veld
Error	Error message, if action will fail	tekst
Result	The primary key value of the inserted row if table has identity column	tekst

Select SQL statement

Optie	Waarde	Type veld
Error	Error message, if action will fail	tekst
Result	Data from database table	tekst

Replace parameter

Optie	Waarde	Type veld
Name	The name of the parameter with the '@' at the beginning	tekst
Value	The value of the parameter	tekst
Error	Error message, if action will fail	tekst