|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Stored Procedures with parameters
Hi,
I am trying to pass a parameter, selected from a drop down html list/form to a stored procedure on a different asp page. Can anybody tell me how to put a result like that into my SQL stored procedure? So far I only need an example that takes one parameter (server name). I have no idea how to do this so any advice needs to be "dumbed down" so I understand it all ThanksCam |
|
#2
|
||||
|
||||
|
Here's a sample stored procedure that accepts a parameter.
CREATE PROCEDURE spSomeName ( @servername varchar(20) ) AS SET NOCOUNT ON SELECT * FROM Table1 WHERE ServerName = @servername SET NOCOUNT OFF GO |
|
#3
|
|||
|
|||
|
Thank you very much.
Cam |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Stored Procedures with parameters |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|