O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required