November 18, 2006 at 9:11 am
I am new to SQL server and as so would really appreciate some help as I am sure that what I am about to ask is a stupid question to anyone with a development background. My background is Cisco/CCNA, Firewalls etc and MSCE but wanting to make a break into development.
I am in the process of studying the T-SQL language and so far all seems good. However everything I am doing means that I am typing the criteria for my queries direct into TSQL using where statements, etc. What my question is, is how could I write a stored procedure and call this by using either ASP, or VB where the user would put the criteria into the procedure that I have written.
I hope this makes sense and I look forward to hearing from anyone that can help me. Thanks in advance.
November 18, 2006 at 2:20 pm
To create the procedure:
create proc 'myProc'
@param1 param1DataType, @param2 param2DataType...
as
...type your code here...
go
About calling the procedure from ASP, see this article:
http://support.microsoft.com/kb/q164485/
Hope that helps.
-M
November 18, 2006 at 3:26 pm
I will give that a try. Thank you for your prompt post M!!
Cheers,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply