You can create a stored procedure from the Data Project Explorer, either from a data development project, from an existing SQL statement in a data development project, or by using the toolbar buttons. You can also create a stored procedure from a database connection in the Database Explorer.
If you create a stored procedure from a data development project, from an existing SQL statement in a data development project, or by using the toolbar buttons, a wizard guides you through the entire process. You can also simply specify a name and language for the stored procedure and then modify the source code in the routine editor. If you create a stored procedure from the Database Explorer, you can use the routine editor or the SQL editor.