To create a TSQL stored procedure query

  1. In your OpenESQL Assistant Options, set Query > Type Stored Procedure to TSQL.
  2. Start the OpenESQL Assistant.
  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.