Viewing Stored Procedures

You can view the source code for stored procedures in SQL Server 2014 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, or use the object_definition() function. Listing 25.10 provides an example of using the sp_helptext stored procedure. However, sp_helptext returns the data in rows representing the way the procedure text is stored in the system tables. There will be some extra line breaks in the result, possibly in the middle of a keyword or object name.

LISTING 25.10 Viewing Code for a Stored Procedure by Using sp_helptext

Click here to view code image

EXEC sp_helptext Emp_DeptGO/* outputText----------------------------------------------------------- ...

Get Microsoft SQL Server 2014 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.

Start your free trial