entityMap|blocks|key|29heq|text|右键单击存储过程并选择|type|unstyled|depth|inlineStyleRanges|entityRanges|data|e7oeo|将存储过程脚本编写为%7C创建到%7C新建查询编辑器窗口/剪贴板/文件|2b02n|..。|9dhsi|您还可以执行以下操作|8mkri|修改|2k129|当您右键单击存储过程时。|am57q|有关一次执行多个过程的信息，请单击|arqps|存储过程|2dsgk|文件夹中，按F7打开对象资源管理器详细信息窗格，按住Ctrl键并单击以选择所需的所有项，然后右击并选择|2uvgh|将存储过程脚本编写为%7C+CREATE+To|ea7kf^0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|V|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|W|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|X|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|Y|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|Z|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|10|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|11|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|12|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|13|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|14|9|@]|A|@]|B|$]]|$2|U|4|F|6|7|8|15|9|@]|A|@]|B|$]]]]

Right click on the stored procedure and select Script Stored Procedure as | CREATE To | New Query Editor Window / Clipboard / File.
You can also do Modify when you right click on the stored procedure.
For multiple procedures at once, click on the Stored Procedures folder, hit <kbd>F7</kbd> to open the Object Explorer Details pane, hold <kbd>Ctrl</kbd> and click to select all the ones that you want, and then right click and select Script Stored Procedure as | CREATE To.

entityMap|blocks|key|1b4u2|text|我想这是查看存储过程代码的更好方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2lpo9|sp_helptext|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

I guess this is a better way to view a stored procedure's code:

<pre><code>sp_helptext &lt;name of your sp&gt;
</code></pre>

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/045def5467afd3821f67913ec1e2a3ff.png|imageAlt|blocks|key|57j4o|text|该选项称为|unstyled|depth|inlineStyleRanges|entityRanges|6sb80|​|dvb7m|ffcki|?|atomic|offset|length|ed0pm|7ihgb|8oq3q|这将在一个新的查询窗口中向您显示存储过程的T-SQL代码，其中包含一个|8n690|因此，您可以轻松地更改或修改您的过程并对其进行更新^0|0|0|0|0|1|0|0|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|X|H|@]|I|@]|6|$]]|$B|J|D|K|2|F|G|Y|H|@]|I|@]|6|$]]|$B|L|D|-4|2|F|G|Z|H|@]|I|@]|6|$]]|$B|M|D|N|2|O|G|10|H|@]|I|@$P|11|Q|12|B|13]]|6|$]]|$B|R|D|-4|2|F|G|14|H|@]|I|@]|6|$]]|$B|S|D|K|2|F|G|15|H|@]|I|@]|6|$]]|$B|T|D|U|2|F|G|16|H|@]|I|@]|6|$]]|$B|V|D|W|2|F|G|17|H|@]|I|@]|6|$]]]]

The option is called <code>Modify</code>:

<img src="https://i.stack.imgur.com/ijmaf.png" alt="enter image description here">

This will show you the T-SQL code for your stored procedure in a new query window, with an <code>ALTER PROCEDURE ...</code> lead-in, so you can easily change or amend your procedure and update it

entityMap|blocks|key|e3u9j|text|这是查看存储过程定义的另一种方式|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6gbn0|SELECT+OBJECT_DEFINITION+(OBJECT_ID(N'Your_SP'))|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

This is another way of viewing definition of stored procedure

<pre><code>SELECT OBJECT_DEFINITION (OBJECT_ID(N'Your_SP'))
</code></pre>

entityMap|blocks|key|fiu43|text|使用以下查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4kq82|SELECT+object_definition(object_id)+AS+[Proc+Definition]
FROM+sys.objects+
WHERE+type='P'|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

Use this query:
<pre><code>SELECT object_definition(object_id) AS [Proc Definition]
FROM sys.objects 
WHERE type='P'
</code></pre>

entityMap|blocks|key|9pirn|text|exec+sp|type|unstyled|depth|inlineStyleRanges|entityRanges|data|d748g|_|2v1ob|帮助文本‘你的|629u5|brsj5|sp|f5kg6|a9pr7|name‘--别忘了引号|fb5n9|在management+studio中，默认情况下结果显示在网格视图中。如果要在文本视图中查看，请转到：|c2nnb|查询-->结果到-->结果到文本|50he3|或CTRL+%2BT，然后执行。^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|S|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|T|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|U|9|@]|A|@]|B|$]]|$2|G|4|D|6|7|8|V|9|@]|A|@]|B|$]]|$2|H|4|I|6|7|8|W|9|@]|A|@]|B|$]]|$2|J|4|D|6|7|8|X|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|Y|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|Z|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|10|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|11|9|@]|A|@]|B|$]]]]

exec sp_helptext 'your_sp_name' -- don't forget the quotes

In management studio by default results come in grid view. If you would like to see it in text view go to:

Query --> Results to --> Results to Text

or CTRL + T and then Execute.

entityMap|blocks|key|dn0jp|text|建议使用对象资源管理器和将存储过程编写为新查询编辑器窗口脚本的其他答案以及其他查询都是可靠的选项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|mc9v|我个人喜欢使用下面的查询来检索单行中的存储过程定义/代码(我使用的是Microsoft+SQL+Server+2014，但看起来这应该适用于SQL+Server+2008和更高版本)|vkkj|SELECT+definition+
FROM+sys.sql_modules+
WHERE+object_id+=+OBJECT_ID('yourSchemaName.yourStoredProcedureName')|code-block|syntax|javascript|685bm|有关sys.sql的更多信息|5nph0|_|6uniu|模块：|579ao|https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-modules-transact-sql^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|T|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|U|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|V|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|W|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|X|9|@]|A|@]|B|$]]]]

The other answers that recommend using the object explorer and scripting the stored procedure to a new query editor window and the other queries are solid options. 

I personally like using the below query to retrieve the stored procedure definition/code in a single row (I'm using Microsoft SQL Server 2014, but looks like this should work with SQL Server 2008 and up)

<pre><code>SELECT definition 
FROM sys.sql_modules 
WHERE object_id = OBJECT_ID('yourSchemaName.yourStoredProcedureName')
</code></pre>

More info on sys.sql_modules: 

<a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-modules-transact-sql" rel="noreferrer">https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-modules-transact-sql</a>

entityMap|blocks|key|cnc45|text|您可以使用以下查询查看数据库中存储的所有对象代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|bmlao|USE+[test]+--Database+Name
SELECT
++++sch.name%2B'.'%2Bob.name+AS+++++++[Object],+
++++ob.create_date,+
++++ob.modify_date,+
++++ob.type_desc,+
++++mod.definition
FROM+
+++++sys.objects+AS+ob
+++++LEFT+JOIN+sys.schemas+AS+sch+ON
++++++++++++sch.schema_id+=+ob.schema_id
+++++LEFT+JOIN+sys.sql_modules+AS+mod+ON
++++++++++++mod.object_id+=+ob.object_id
WHERE+mod.definition+IS+NOT+NULL+--Selects+only+objects+with+the+definition+(code)|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

You can view all the objects code stored in the database with this query:

<pre><code> USE [test] --Database Name
SELECT
 sch.name+'.'+ob.name AS [Object], 
 ob.create_date, 
 ob.modify_date, 
 ob.type_desc, 
 mod.definition
FROM 
 sys.objects AS ob
 LEFT JOIN sys.schemas AS sch ON
 sch.schema_id = ob.schema_id
 LEFT JOIN sys.sql_modules AS mod ON
 mod.object_id = ob.object_id
WHERE mod.definition IS NOT NULL --Selects only objects with the definition (code)
</code></pre>

entityMap|blocks|key|7sc37|text|如果你没有“修改”的权限，你可以安装一个免费的工具，叫做"SQL+Search“(由Redgate提供)。我使用它来搜索我知道会出现在SP中的关键字，它会返回SP代码的预览，并突出显示关键字。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|c1aaf|巧妙！然后，我将此代码复制到我自己的SP中。^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

In case you don't have permission to 'Modify', you can install a free tool called &quot;SQL Search&quot; (by Redgate). I use it to search for keywords that I know will be in the SP and it returns a preview of the SP code with the keywords highlighted.
Ingenious! I then copy this code into my own SP.

entityMap|blocks|key|ebn7|text|这是更好的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|ajl3q|SELECT+object_definition(object_id)
FROM+sys.objects+
WHERE+type='p'+and+name='SP_Name'|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

This is the better way :
<pre><code>SELECT object_definition(object_id)
FROM sys.objects 
WHERE type='p' and name='SP_Name'
</code></pre>

I am new to SQL Server. I am logged into my database through SQL Server Management Studio. 

I have a list of stored procedures. How do I view the stored procedure code? 

Right clicking on the stored procedure does not have any option like <code>view contents of stored procedure</code>.

Thanks.

How to view the stored procedure code in SQL Server Management Studio

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

 我不熟悉SQL Server。我已通过SQL Server Management Studio登录到我的数据库。 我有一个存储过程列表。如何查看存储过程代码？ 右键单击存储过程没有任何选项，例如 ..。 谢谢。

问如何在SQL Server Management Studio中查看存储过程代码
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server Management Studio中查看存储过程代码EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQL Server Management Studio中查看存储过程代码
EN