To create a TSQL stored procedure query
- Start the OpenESQL Assistant.
- Select
Tools > Options and make sure
Type Stored Procedure is set to
TSQL.
- 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.
