How do you build an stored procedure that will return an ADO recordset when called from within VB6

How do you build an stored procedure that will return an ADO recordset when called from within VB6. I just want the stored procedure side in this question. Calling a sp from VB is another question
Vincent_MonaghanAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
create procedure yourprod (@param1 int)
as
SET NOCOUNT ON
select fields
from yourtable
where key = @param1

0
 
Vincent_MonaghanAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.