List all the stored procedure in Database

Posted Date: 07 Aug 2008 Resource Type: Code Snippets Category: SQL

Posted By: lavanya Member Level: Gold
Rating:

Points: 2

This code sample is a query that lists all the stored Procedure in a Database. Here 'P' implies stored procedures. The list is obtained using sys.objects table that contains all objects associated with a database.



select name from sys.objects where type = 'P'

Responses

Author: amit chaudhary 22 Aug 2008 Member Level: Silver Points : 1

This Store Procedure helps us to get values from the database.

Create Procedure GetnameById
(
@Id int,
@name varchar,50 OUTPUT
)
As
SELECT @name = name
FROM emp
WHERE id = @Id

Feedbacks

Popular Tags

What are tags ?

Search Tags

List Stored Procedures in Database . List all stored procedures in a Database . List all stored procedures . All stored procedures in a Database .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: List all the tables from the database
	Previous Resource: List all the Triggers in a Database
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj