How are stored procedures saved or stored?

Question

0.00/5 (No votes)

See more:

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?

Posted 4-Feb-14 0:17am

Gbenbam

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pete O'Hanlon · Answer 1 · 2014-02-04T00:27:00

Solution 1

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:

SQL

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

Posted 4-Feb-14 0:27am

Pete O'Hanlon

Comments

Gbenbam 4-Feb-14 6:40am

How does one store them there in the first place?Will one create them at run time and store them in a field of a record in a table?

Pete O'Hanlon 4-Feb-14 6:46am

The syntax of creating or amending a stored procedure takes care of this for you - you don't actually have to do much beyond add CREATE or ALTER PROC at the start to let SQL Server know what to do with the procedure.

Dhruvin Sukhadiya · Answer 2 · 2014-02-04T00:30:00

Solution 2

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[^]

Posted 4-Feb-14 0:30am

Dhruvin Sukhadiya