Database Reference
In-Depth Information
Figure 6-6.
Executing the modified stored procedure
How It Works
After you've executed the
ALTER PROCEDURE
statement, the stored procedure is updated in the database.
Alter procedure sp_Select_All_PersonContact
You also added the
Order by
clause while modifying the procedure.
order by Contact.LastName
Displaying the Definition of Stored Procedures
SQL Server offers a way to view the definition of the objects created in the database. This is known as
metadata retrieval
. The information about objects is stored in some predefined system stored
procedures that can be retrieved whenever required.