当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server 2005 - 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')

网友答案:

I think you want

exec sp_helptext 'MyFunctionOrProcedureName'
分享给朋友:
您可能感兴趣的文章:
随机阅读: