Find procedure and function in SQL Server

Posted by Kunal Vaishya in Blogs | SQL on Oct 26, 2012

Find procedure and function from this query.

ROUTINE_TYPE = 'PROCEDURE' OR 'Function'

Select ROUTINE_TYPE,SPECIFIC_NAME,ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE OBJECTPROPERTY(OBJECT_ID(SPECIFIC_NAME),'IsMSShipped') =0

AND ROUTINE_DEFINITION like '%prcleave%'

AND ROUTINE_TYPE='PROCEDURE'

This Feature is Sponsored By

Make Your Data Do More with the Ignite UI Grid. Launch eye-popping, performance-driven HTML5 apps w/ Ignite UI's free jQuery Grid.

comments

COMMENT USING

PREMIUM SPONSORS

Infragistics

Infragistics is experts in technology and design, and passionate about helping you build highly performant and stylish applications that solve problems, deliver inspiration, and maximize results.

More Blogs from this Blogger

Query to Repair Suspect Database In SQL Server Create Desktop Gadgets Using C# Window Application Deleting Duplicate Records in SQL Table Adding New Field In Database Find procedure and function in SQL Server Fetch Comma Separated Data using XML Path Query to Get Nth Highest Value Get a column value in a single coma separated string in SQL How to Add ToolTips to Individual Cells in a Windows Forms DataGridView Get ALL Procedures Using One Query

View All

SPONSORED BY

Get the industry leading .NET Diagramming component

.NET Diagramming framework designed for creating advanced solutions

Follow @twitterapi

Latest Blogs

How to use Custom Attribute in HTML Element Show Your Current Age in MVC How to Calculate Age in Year in ASP.NET Delete Files from a Folder Inside a Application after Uploaded in ASP.Net Count Number Of Days Between Two Dates And Display Date in VB.NET Encapsulate Field and Extract Interface in .NET No HTTP resource was found that matches the request URI in MVC 4 Web API Check Database Connection in MySQL using C# Why Developers Should Read News In Defence of Books

View All

Poll Result All Polls


Speed of C# Corner

How do you find speed of C# Corner when visiting the site?

Very Fast OK Slow Very Slow

Options	Votes	%
Very Fast	6	9.23
OK	50	76.92
Slow	6	9.23
Very Slow	3	4.62
Total	65	100%

In Focus

Find procedure and function in SQL Server