Professional Web Applications Themes

sp_helptext - Microsoft SQL / MS SQL Server

Exec sp_helptext functionname This returns a column named text. My question is is there way I could search some words from this column using a select statement. I want to search all words with prefix 'Met%', 'Sen%' and 'Blu%'. Soemthing like Select * from Exec sp_helptext functionname where text like 'Met%' or text like 'Sen%' etc. etc. I don't know the how this sp_helptext stores the text and in what table... Thanks for help...

  1. #1

    Default sp_helptext

    Exec sp_helptext functionname

    This returns a column named text. My question is is there
    way I could search some words from this column using a
    select statement. I want to search all words with
    prefix 'Met%', 'Sen%' and 'Blu%'.

    Soemthing like

    Select * from Exec sp_helptext functionname where text
    like 'Met%' or text like 'Sen%' etc. etc.

    I don't know the how this sp_helptext stores the text and
    in what table...

    Thanks for help
    Ricky Guest

  2. #2

    Default Re: sp_helptext

    AJ,

    That's not entirely true.

    You can check INFORMATION_SCHEMA.ROUTINES in sql2k for
    function/procedure/trigger text.
    http://msdn.microsoft.com/library/en-us/tsqlref/ts_ia-iz_3kq1.asp?frame=true


    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net



    "Andrew John" <com> wrote in message
    news:u31i%phx.gbl... 
    multiple rows in 
    news:09d901c35c78$91350db0$gbl... 
    >
    >[/ref]


    oj Guest

  3. #3

    Default Re: sp_helptext

    oj,

    My mistake, thanks for the pointer.

    AJ

    "oj" <com> wrote in message news:e%phx.gbl... 


    Andrew Guest

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139