[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

using Stored Procedures for Access97

Posted on 1998-08-27
3
Medium Priority
?
223 Views
Last Modified: 2010-03-19
HI,
how do i use a stored procedures of sQL SErver 6.5 from within Access97 environment?
thanks.
0
Comment
Question by:msali
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
DennisH earned 80 total points
ID: 1089791
Create a new query.  Select Query/SQL Specific/Pass Through from the menu. In the SQL window type the following SQL statement.

EXEC sp_myprocedure

Where sp_myprocedure is the name of your stored procedure.

Open the properties window for the query and set the properties.  Pay close attention to setting the Connect string and the "ReturnsRecords" properties correctly.  Save your query and test it.
0
 

Author Comment

by:msali
ID: 1089792
How about the parameters?
0
 
LVL 1

Expert Comment

by:DennisH
ID: 1089793
You did not ask about parameters.  You use the same format except you add the arguments in the correct order.

Example:
EXEC sp_esr_CalculateStatistics 'E', 1, 1997

You must pass the arguments as the proper data type.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question