Editing a Stored Procedure in Microsoft SQL Server

User Guide > Procedures > Physical Stored Procedures > Editing a Stored Procedure in Microsoft SQL Server

The stored procedure discussed in this section is in a data source called Northwind in a Microsoft SQL Server database, with two scalar parameters whose directions are known. The stored procedure returns a cursor, which has two columns. The cursor will not be introspected during data source introspection. If you use the Design By Example window, both cursors will always be found in the same order (unless the stored procedure has changed because of introspection).

To edit a stored procedure that returns a single cursor

1. Open the stored procedure by double-clicking the stored procedure or right-clicking it and selecting Open.

The editor opens on the right. This stored procedure has one input parameter and one output parameter.

2. You can design the cursor manually or by using the Design By Example tool, as described in Editing a Stored Procedure in an Introspected Data Source.