Results 1 to 4 of 4

Thread: How to count no of lines in stored procedure

  1. #1
    Join Date
    Oct 2007
    Posts
    1

    How to count no of lines in stored procedure

    Hi,

    how can I get the no of lines in my stored procedure.

    sp_helptext procname returen procedure text if we can store this content in table we get the count from that table.

    Please help me, how can I do this.

    Thank you

    - Madhu

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Query analyzer tells you that.

  3. #3
    Join Date
    Oct 2007
    Posts
    1

    Post One of Possible query

    Hi Madhu,

    I think u can use the following query to find the line count from procedure.

    SELECT COUNT(1) FROM USER_SOURCE
    WHERE
    NAME='&object_name'

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    What's USER_SOURCE? Is it for sql server?

Posting Permissions

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