Microsoft® SQL Server 2012 Unleashed

Viewing Stored Procedures

You can view the source code for stored procedures in SQL Server 2012 in a number of different ways. You can query the definition column of the object catalog view sys.sql_modules, use the system procedure sp_helptext, query the INFORMATION_SCHEMA routines view, or use the object_definition() function. Listing 24.10 provides an example of using the sp_helptext stored procedure.

LISTING 24.10 Viewing Code for a Stored Procedure by Using sp_helptext

Click here to view code image

EXEC sp_helptext Emp_DeptGO/* outputText-----------------------------------------------------------CREATE PROCEDURE Emp_DeptASBEGIN   SELECT p.Lastname, p.FirstName, d.Name      FROM HumanResources.Department d      JOIN HumanResources.EmployeeDepartmentHistory ...