Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    38

    Unanswered: Stored Procedure

    Hi,

    I am using Sybase ASE 12.0.

    I have a query on the system stored procedures like sp_who, sp_addlogin etc.

    I understand that Stored Procedure have 'cursors' implemented in them. I would like to know the content/text that goes into a system procedure.

    For example: what is the content of sp_who?

    Can I see it somewhere? Is it documented? can i see it after logging into isql?

    Anu_R

  2. #2
    Join Date
    Dec 2002
    Posts
    104

    Re: Stored Procedure

    Originally posted by Anu_R
    Hi,

    I am using Sybase ASE 12.0.

    I have a query on the system stored procedures like sp_who, sp_addlogin etc.

    I understand that Stored Procedure have 'cursors' implemented in them. I would like to know the content/text that goes into a system procedure.

    For example: what is the content of sp_who?

    Can I see it somewhere? Is it documented? can i see it after logging into isql?

    Anu_R
    hello anu,

    u can see the text of these system procedures in database known as sybsystemprocs with the help of sp_helptext

    For eg:

    sp_helptext sp_who.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •