Microsoft KB Archive/74240

{| = Executing Stored Procedures with Parameters from QE =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q74240

SUMMARY
You may supply parameters when executing a stored procedure from Q+E. The name of the stored procedure must be followed by a space and then the first parameter. Additional parameters must be separated by spaces and listed in order.

MORE INFORMATION
Note: You must be using Q+E version 2.5 or later to access a SQL Server.

When you choose Open from the File menu and select SQLServer as the Source, Q+E will display the names of all available tables and stored procedures to which you have access. The name of each stored procedure will be preceded by the at sign (@).

The following example executes the stored procedure sp_addlogin and adds the login id &quot;tester&quot;:


 * 1) Start Q+E.
 * 2) From the File menu, choose Logon.
 * 3) Log on to a SQL Server.
 * 4) From the File menu, choose Open.
 * 5) Select SQLServer for the source.
 * 6) Choose the master database.
 * 7) Select @sp_addlogin from the from Table List.
 * 8) After &quot;@sp_addlogin&quot; in the Table Name box, enter a space and then &quot;tester&quot; (without the quotation marks).
 * 9) Choose OK.

Q+E will display an alert telling you that the command was completed. For more information on stored procedures, see your SQL Server documentation.
 * }