Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    1

    Unanswered: Counting Number of lines in procedures

    Was wondering if there is a solution or any tips in counting the number of lines in all the procedures in a database. I have tried the sp_helptext option but this is inaccurate. Am also aware of the syscomments table with the text field which unfortunately has "char(13)" embedded in them....so not very useful....

    Any help is appreciated greatly!

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Quote Originally Posted by an2000 View Post
    Was wondering if there is a solution or any tips in counting the number of lines in all the procedures in a database. I have tried the sp_helptext option but this is inaccurate. Am also aware of the syscomments table with the text field which unfortunately has "char(13)" embedded in them....so not very useful....

    Any help is appreciated greatly!
    In ASE 15.0, this is possible.

    sp_helptext sp_help, NULL,NULL,'showsql,linenumbers'

    If you are using ASE 12.5, maybe look at the code of ASE 15 sp_helptext and see if it helps?

Posting Permissions

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