To create a TSQL stored procedure query

  1. Start the OpenESQL Assistant.
  2. Select Tools > Options and make sure Type Stored Procedure is set to TSQL.
  3. Connect to a Microsoft SQL Server data source.
  4. Check the box next to a table name.
  5. Click a query type from the list.
  6. Check Generate Query as a TSQL Stored Procedure.
  7. In the SP name field, type a name for the stored procedure. Alternatively, accept the default value.
  8. Click OK.
  9. Continue to build your query.
Parent topic: OpenESQL Assistant
Related concepts
Generating a TSQL Stored Procedure Query
Select Type of Query to Create dialog box
OpenESQL Assistant
Building Queries
Setting OpenESQL Assistant Options
Stored Procedures