Web Query




The Web Query module is used to execute ad-hoc Transact-SQL queries against SQL Server data sources.


This module requires specific configuration prior to use in the Module Settings editor. Please see the Web Query Configuration page for configuration instructions.


This module functions outside the realm of the normal permissions hierarchy.  It can be viewed only by a user with membership in Site Administrators site-level roles with no regard to permissions assigned to the tab on which the module is placed.  For more information on the roles referenced in this section please see the role based security topic.  Administrative users can configure additional module settings by clicking the  button.


Writing Queries


The administrative user can configure the following attributes:


SQL Script: This is the Transact-SQL syntax to submit to the server.  Any valid SQL statements can be issued but the code will not recognize the batch terminator keyword GO in the script.

Wrap Cell Contents in Results: When checked cell contents can wrap.  The default behavior is to not wrap which may cause the results to scroll very wide.

Use Integrated Security: When checked the hosting credentials for the interactive user will be used instead of the application pool identity (which is very low powered with extreme limitations).

Encode Results: When checked the contents of any results will be HTML encoded prior to display to prevent HTML markup in the results from being displayed or scripts from being executed.

Allow Sorting: When checked the user can sort the results of any data table returned by clicking column names in the data table.


Query Results


Execute the batch by pressing the Execute button.  The results will be displayed in a tab set below the button.  There will be one tab for each tabular result set received during execution.  There will also be a Messages tab present with the output of any non-tabular statement including printed messages and exceptions if any such messages are intercepted.


Copyright © 2023 pasUNITY, Inc.


Send comments on this topic.