Post reply

How do I return a recordset or table from a stored procedure

  • January 16, 2006 at 7:20 am

    #96441

    Hi

    How do I return a recordset or table from a stored procedure?

    Regards

    Kjell Arne Johansen

  • January 16, 2006 at 8:21 am

    #614928

    Hi,  For your ref

    SQL Server 2000 stored procedures return data in four ways: Output parameters,Return codes,A result set for each SELECT statement,A global cursor that can be referenced outside the stored procedure.

    e.g.

    CREATE PROCEDURE GetAuthorsByLastName(@au_lname varchar(20))

    AS

    select * from authors where au_lname=@au_lname;

    GO

     

     

    Regards
    Shrikant Kulkarni

  • January 16, 2006 at 11:58 pm

    #615055

    Thank You!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply