TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Get ALL Procedures Using One Query
Kunal Vaishya
Jul 04, 2012
3.3
k
0
0
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
We can get get all procedure text using a single query in SQL Server.
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'
Get ALL Procedures Using One Query
Next Recommended Reading
Call Stored Procedure Inside Another Stored Procedure