Product Home
Publish Table to HTML for SQL Server Prev Page Prev Page
Product profile
User interface
Select Source Table
Data Preview
Settings Window
Command line
Database query
Select Target Table
Select Columns
Select Target File
Text Output
SQL Output
XML Output
Excel Output
Select Objects
Select Schema Objects
Technical support
Install and Uninstall

Database Query

This window helps you to enter a database query (SQL statement) or to load one from the disk file.
Also, you can preview data to be exported.

Publish Table to HTML for SQL Server: Database Query Window

The database query can be parametrized by swtching on related checkbox at this window. You should use #NAME# parameters instead of immediate values. Maximum parameyter name length is 7 symbols.

The program will ask user for parameter value when execute a query:

Publish Table to HTML for SQL Server: Prompt for Parameter Window