Execute SQL Action

   

[FinalBuilder Professional Edition]

 

Execute an SQL statement against Microsoft SQL Server and capture the result set.

 

Connection & Security

 

sqlconn

 

Server - Specify the MS SQL Server to use.  Clicking "View List" will attempt to locate any SQL Servers on the network.

Use Database - Specify a database to run the SQL against.

 

SQL Server Tool - choose the method (isql, osql or sqlcmd) to use to connect with.

 

Security - If not using integrated (ie. Windows) security, you should specify the username and password to use.

 

Input

 

sqlinput

 

SQL Input - SQL Script from file - specify a file which contains an SQL Script.

         - Text Query - Specify the SQL Query to execute.

 

For information on the other options see:

 

isql : http://msdn.microsoft.com/library/en-us/coprompt/cp_isql_8r39.asp

osql : http://msdn.microsoft.com/library/en-us/coprompt/cp_osql_1wxl.asp

sqlcmd : http://msdn2.microsoft.com/en-us/library/ms162773.aspx

 

Output

 

sqloutput

 

The query results can either be output to a file or to the FinalBuilder Log.

For information on the other options see:

 

 

isql : http://msdn.microsoft.com/library/en-us/coprompt/cp_isql_8r39.asp

osql : http://msdn.microsoft.com/library/en-us/coprompt/cp_osql_1wxl.asp

sqlcmd : http://msdn2.microsoft.com/en-us/library/ms162773.aspx

 

 

To set the location of ISQL, OSQL and SQLCmd see SQL Server Options