Pass variable to SQL Server

[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

 

[Stefan Hoffmann]

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.

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 <--