build stored procedure

Hi,

I would like to know where I can know more about how to build stored procedure.

Thank you

look up stored procedure on the BOL (Books Online). it can be found on the start > programs > Microsoft sql server > Books Online|||

Thank you.

I have another question. can I add a new stored procedure to MS Access?if so, how?

|||

MS Access databases (*.mdb files, using JET) DO NOT support stored procedures.

However, if a SQL Server is being used either as a linked queries, or with a data project (*.adp), then you can add stored procedures to SQL Server.

|||

I am not sure how to create a sp from Access Application.

But the provider supports you to create a procedures..

When i worked with Access(97), I used the following VBScript to create procedures...

Code Snippet

' VBScript source code

Dim oConn As New ADODB.Connection

Dim oRs As New ADODB.Recordset

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\Database1.mdb;Persist Security Info=False"

Call oConn.Execute("Create Procedure MyNewProc as Select * From Table1") ' Here You can create a new proc as you like

Set oRs = oConn.Execute("Exec MyNewProc")