如何在 SQL Server Management Studio 中查看存储过程代码 [英] How to view the stored procedure code in SQL Server Management Studio

问题描述

我是 SQL Server 的新手.我通过 SQL Server Management Studio 登录到我的数据库.

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 view contents of stored procedure.

谢谢.

推荐答案

右键单击存储过程并选择 Script Stored Procedure as |创建到 |新的查询编辑器窗口/剪贴板/文件.

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.

对于多个过程，单击Stored Procedures文件夹，点击F7打开对象资源管理器详细信息窗格，按住Ctrl并单击以选择所需的所有内容，然后右键单击并选择 Script Stored Procedure as |创建到.

For multiple procedures at once, click on the Stored Procedures folder, hit F7 to open the Object Explorer Details pane, hold Ctrl and click to select all the ones that you want, and then right click and select Script Stored Procedure as | CREATE To.

这篇关于如何在 SQL Server Management Studio 中查看存储过程代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！