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.
EXEC sp_helptext Emp_DeptGO/* outputText-----------------------------------------------------------CREATE PROCEDURE Emp_DeptASBEGIN SELECT p.Lastname, p.FirstName, d.Name FROM HumanResources.Department d JOIN HumanResources.EmployeeDepartmentHistory ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.