You can use the New Stored Procedure wizard to create stored
procedures.
Before you begin
Ensure the following requirements are met:
About this task
Routine development using a wizard is not supported for
every available data source. See Routine support by server type for
details.
Procedure
To create a stored procedure from a data development
project:
- In the Data Project Explorer, right-click the Stored
Procedures folder in a data development project, and click
. The New Stored Procedure wizard opens.
- Complete the steps of the wizard.
If you
opened the wizard by using the toolbar button, you must provide project
and connection information in the wizard.
After you specify
a name and language, select a template to use as the starting point
for your stored procedure. Some templates are included with the product,
or you can create your own templates to share with other team members
using the Preferences page.
Results
The wizard creates the stored procedure and adds it to the
Stored
Procedures folder, and the stored procedure opens in the
Routine editor.