存储过程如何保存或存储？ [英] How are stored procedures saved or stored?

问题描述

当一个人写一个存储过程时，请将其写入amd保存。我希望它们不会在运行时创建它们是否被创建并保存在文本文件中或者是什么。如何将它们置于文本文件的范围内program？

Please when one writes a stored procedure, where is it written to amd saved.I expect that they are not created at run time Are they eritten and saved in a text file or what.How are they placed within the reach of the program?

推荐答案

存储过程存储在数据库中（这就是它们被称为存储过程的原因）。文本存储在系统表中 - 您可以从 sys_modules 中检索如下：

Stored procedures are stored in the database (that's the reason they are called stored procedures). The text is stored in system tables - you can retrieve if from sys_modules like this:

select * from sys.sql_modules where object_id=object_id('MyStoredProcedure')

查看本网站



1. SQL Server存储过程概述 [ ^ ]



2. http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/ [ ^ ]



3. http://www.aspdotnet-suresh.com/2011/07/what-is-stored-procedure-in-sql-server。 html [ ^ ]

REVIEW THIS SITES

1. Overview of SQL Server Stored Procedure[^]

2.http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/[^]

3.http://www.aspdotnet-suresh.com/2011/07/what-is-stored-procedure-in-sql-server.html[^]

这篇关于存储过程如何保存或存储？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！