my code stock.com

Sonya Curry

FIND CODE for Stored Procedure SQLSRV
by Sonya Curry

—find the actual code for a particular stored procedure, view, function etc. Change the MyObjectName for the name of the routine whose code you want.

Snippet options

Download: Download snippet as find-code-for-stored-procedure-sqlsrv.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

--find the actual code for a particular stored procedure, view, function etc.
--Change the MyObjectName for the name of the routine whose code you want
Select object_Name(object_ID),definition from sys.SQL_Modules
where object_Name(object_ID)='MyObjectName'

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.