September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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 28.2 shows an example of the default template code for a stored procedure that would be opened into a new query window.
Listing 28.2 An Example of a New Stored Procedure Creation Script Generated by SSMS

You can modify the template code as necessary to ...