|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: What are Stored Procedures? |
|
From: |
Harlan |
|
Date: |
3/8/1999 9:22:10 AM |
|
IP: |
206.222.20.2 |
I wasn't going to answer this because any book (and you did look it up before asking it right) should have the answer, and I only like to answer questions that can't be answered in any book. But, what the hell.
a stored procedure is: a group of sql statements that can be saved and referenced by name. In access they are called 'queries' I believe.
your question:
I've seen references to them at various news groups but how do you use them?
-you reference them just like any database, they return recordsets (most of the time).
How do you store them?
-not sure in access, I think you can "query view" or something and write the sql in there, I'm sure there are wizards and stuff too, but I have no idea how to use them.
Can they be used with an Access database thru ODBC?
-yes, but remember in access they are called queries not stored procedures.
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
