To create a stored procedure in SSMS, open the object tree for the database in which you want to create the procedure, open the
Programmability folder, right-click the
Stored Procedures folder, and from the context menu, choose New Stored Procedure. SSMS opens a new query window, populated with code that is based on a default template for stored procedures. Listing 24.2 shows an example of the default template code for a stored procedure that would be opened into a new query window.
-- ================================================-- Template generated from Template Explorer using:-- Create Procedure ...