To create a TSQL stored procedure query
- In your OpenESQL Assistant Options, set
Query > Type Stored Procedure to
TSQL.
- Start the OpenESQL Assistant.
- Connect to a Microsoft SQL Server data source.
- Check the box next to a table name.
- Click a query type from the list.
- Check
Generate Query as a TSQL Stored Procedure.
- In the
SP name field, type a name for the stored procedure. Alternatively, accept the default value.
- Click
OK.
- Continue to build your query.
