IMG-LOGO
Home Blog TSQL

How to view stored procedure content using SQL Management Studio or Using SQL Query Code?

andy - 01 Jan, 2014 2873 Views 0 Comment

There are two ways to view the content of a stored procedure in SQL Server. First one is to use SQL Management Studio and the other one is to use Sql Query code.

1. Using SQL Management Studio.

You can view the content by using SQL Management Studio. This application is a windows software and need to be installed in your computer in order to view it. Once installed and connected to the SQL Server, you can expand the database stored procedures you want to see.

2. Using Sql Query Code

Alternatively you can use sql query code to view the content of the stored procedure. 

/* Remember that the quote is required */
sp_helptext 'Stored_ProcedureName'
Share:
Facebook Twitter

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Articles

How to restore database using SQL query in TSQL?

TSQL
26 Feb, 2021
If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

How to get all table sizes in TSQL?

TSQL
20 Feb, 2021
To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...