Storage Procedure

[starvin]

Can a Stored Procedure be accessed directly from an Active Server Page document where submitted form field values are a necessary query variable?

 

[tlbroadbent]

Sure can! Instead of a "Select * From Table1" type of query you would do something like "Exec MyStoredProc param1, param2, param3... ". Place single quote (') around any string or text parameters. Terry

http://members.home.net/tlbroadbent/index.htm

 

[youngun]

Check your SQL Books Online (it is part of your SQL server), and go to index-->ado-->stored procedure (or parameters), they have good details.

Caution: the example is not for ASP, but VB. But you can get an idea of how to do it.