Use stored procedures to build complicated applications through a variety of features.
- In the Navigator, expand Databases, right-click a database or user, and select Show Procedures.
-
In the Object List Viewer toolbar, click
.
- Enter values for the new stored procedure.
- [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new procedure.
- Click Commit then OK.