SQL

Get ALL Procedures Using One Query

We can get get all procedure text using a single query in SQL Server. 

Just run this query.

Select Object_Name(C.id) AS Name , text From SysComments AS C Left Join SysObjects AS O  On C.id = O.id  Where O.xtype = 'P'
Ebook Download
View all
Basic SQL Queries
Read by 19.4k people
Download Now!
Learn
View all
Membership not found