Does anyone have any directions on how to convert MS Access Queries into 
Stored Procedures so that I can use them in DreamweaverMX?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "david j potter" <djpotte@p...>
Subject: [access_asp] Converting Queries into Stored Procedures??


: Does anyone have any directions on how to convert MS
: Access Queries into Stored Procedures so that I can
: use them in DreamweaverMX?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Access doesn't have "Stored Procedures". All is has is "parametised queries"
which you can save in the .mdb file.

This may be different if you create an Access Data Project (ADP) that uses
the MSDE engine instead. If that's the case, you need to read SQL Server
Books Online for syntax. But basically it'll look something like:

CREATE PROCEDURE usp_MyTestSproc

    @MyFirstParam    varChar(100),
    -- Other parameters here

AS

    DECLARE @MyVariable    int
    -- Declare other variables here

    -- Query goes here

GO

GRANT EXEC ON usp_myTestSproc TO PUBLIC

GO

Books Online can be downloaded from:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Cheers
Ken