To build a stored procedure in SQL Server, follow these steps:  On the SSMS toolbar, select New Query. Create a procedure by typing (or pasting) a CREATE PROCEDURE statement On the toolbar, click the Execute button. The stored procedure will now be added to the database. In the Object Explorer, it’s under the Stored Procedures node.