Pass variable to SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I pass a variable to a stored procedure in SQL Server? I want the
variable to come from a field in an access form.
--
Billy Rogers

Dallas,TX

Currently Using Office 2000 and Office 2003
 
hi Billy,
How can I pass a variable to a stored procedure in SQL Server? I want the
variable to come from a field in an access form.
Click to expand...
This depends on how you like to call the SP. Which way do you like to use:

- ADO.Command
Use the Parameters collection.

- Passthrough Query
EXEC SP(parameters);

or are using an .adp?


mfG
--> stefan <--
 
Back
Top