You can use SQL Editor or the Routine Editor to create stored procedures.
Using the SQL Editor, you can create a stored procedure based on a template, and modify the template as needed. This method is useful if you want to quickly create a stored procedure and run it on the server.
Using the Routine Editor, you can specify the name and language for a stored procedure and then open the source code in the Routine editor for further modification. When you create a stored procedure using this method, you must specify a data development project to store the source code for the stored procedure. You can specify an existing project that is associated with the connection that you are using, or you can create a new project.
To create a stored procedure from the Server Explorer: