EMS logo

Products Navigation

Data Export for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Export for SQL Server

On-line Documentation

Using query parameters


Both the GUI Wizard and the console version of Data Export for SQL Server support parameters in a query.

 

For example, you export data from a table named table1 and at Step 3 of the GUI version of the utility you specify the following query, e.g. Query_0:

 

SELECT * FROM table1 WHERE field1 > :param0

 

Then you need to save the template file which will be used in the console version of the utility. To set the parameter value when using the console version, you need to specify the following command in the command line (if you run the console version from the program installation directory and the template file is also located in this directory):

 

MsExportC.exe TemplateFile -Query_0:param0=5

where 5 is the query parameter value

 

If you export data from multiple queries, you need to specify the following command in the command line:

 

MsExportC.exe TemplateFile -Query_0:param0=5 -Query_1:param1=10 -Query_2:param2=15

where 5, 10, 15 are the query parameter values

 

 


See also:

Working with console application