Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-15 : 09:39:46
|
Daniel writes "Hello,
sorry if this is a bit of a basic question, but I've had a thorough look through the BOL and also this site, and can't quite find the answer I'm looking for.
I have a little SP (needing further development), that performs a simple query on a table and returns a local variable. What I want to know is, how can I get the SP to return that variable to my ASP page? I've checked out all the ADO Command methods, and they look like being a bit over the top.
My code is:
CREATE PROCEDURE dbo.web_GetMaxRecord
AS
DECLARE @MaxRecords int
SELECT @MaxRecords = MaxCount FROM CurrentRecordCount
WHERE SUBSTRING(CONVERT(varchar,TodaysDate,103),1,10)
= SUBSTRING(CONVERT(varchar,GetDate(),103),1,10)
RETURN (@MaxRecords)
So how can I return the value of @MaxRecords both in SQL and in ASP?
Thank you,
Daniel Newman." |
|
|
|
|
|
|
|
Return a value from a Stored Procedure