I've tried everything I can think of to pass a parameter to a stored procedure and nothing works. Is it possible to pass a variable to a stored procedure using ASP and if so how?
I don't use SQL Server and so don't use stored procedures.<BR><BR>But the answer is: Yes, it is not only possible it isn't all that hard. Many examples appear in the Databases forum here on a very regular basis.<BR><BR>
Well<BR><BR>open a connection<BR><BR>and the sql you execute as the sp name<BR>and then<BR><BR>sql = "spGetYear "& Year(Now) <BR><BR>that would pass year to the proc