SQL Query: How to query a function/procedure body-script

is there any Query syntax (predefined )in SQL Server can show a function/procedure body-script?

sth like:

Select * from ShowScript('MyFunctionOrProcedureName')
开发者_如何学JAVA

---

I think you want

exec sp_helptext 'MyFunctionOrProcedureName'