Just wanted to quickly check the stored procedure
logic from the SQL Query Analyzer. SQL Server allows us to view the
definition, information, and dependencies of a stored procedure,function and triggers.
1. To view the definition
of a stored procedure:
sp_helptext procedureName
2. To view the
information about a stored procedure:
sp_help procedureName
3. To view the
dependencies of the stored procedure:
sp_depends procedureName
'procedureName'
is name of stored procedure,function and triggers also. You can also put these 'procedureName'
between single quote.
If you are going to view function
then put function name such as
sp_helptext GetDownlinePairCountInfo
Sp_helpText is very good
option for viewing the sp’s, Trigger’s , View’s and functions.
Comments
Post a Comment