Using Stored Procedures - Beginning C# 5.0 Databases - page 90

Try It: Viewing the Definition of Our Stored Procedure

1. Enter the following statement in the query pane:

Execute sp_helptext 'sp_Select_All_Employees'
sp_helptext 'sp_Select_All_PersonContact'

2. Go to the Query menu, point to Results To, click Results to Text, and then click
Execute. You will see the same definition that you have specified for your
stored procedure. You can see the output in Figure 6-7.

Figure 6-7. Displaying the definition of the stored procedure

How It Works
The statement sp_helptext is a predefined SQL Server stored procedure that accepts an object name as a
parameter and shows the definition of the object passed to the sp_helptext as the parameter.
sp_helptext

'sp_Select_All_PersonContact'