Using Stored Procedures

lintacious · August 12th, 2003, 04:00 PM

Are stored procedures supposed to be external files?
If so, should they have a file extension?
If not, then I assume once the stored procedure is uploaded that the file extension should be taken off of it?
I assume (if it is an external file) that the stored procedure has to be in the same folder as the asp document calling it, is this the case?

Imar · August 12th, 2003, 04:06 PM

Hi there,

Stored procedures are not stored in files, but inside the database. In SQL Server, for example, you'll find them under the Stored Procedures node of the database.

You can script them to a source file (usually with an .SQL extension, but since they are just plain text, anything will do) but that will just hold the source code of the procedure. They won't work or can be accessed outside the database environment.

In what environment are you trying to use stored procedures?

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.