Microsoft® SQL Server 2012 Unleashed

Creating Procedures in SSMS

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.

LISTING 24.2 An Example of a New Stored Procedure Creation Script Generated by SSMS

Click here to view code image

-- ================================================-- Template generated from Template Explorer using:-- Create Procedure ...