Professional Web Applications Themes

Default Stored Procs Parameters value - Microsoft SQL / MS SQL Server

In which system table are stored the defaults values defined for the parameters on stored procedures? I know the parameters are stored on syscolumns table, but I can't find where are the default parameters values. Thanx Roberto...

  1. #1

    Default Default Stored Procs Parameters value

    In which system table are stored the defaults values defined for the
    parameters on stored procedures? I know the parameters are stored on
    syscolumns table, but I can't find where are the default parameters values.

    Thanx Roberto


    Roberto Guest

  2. #2

    Default Re: Default Stored Procs Parameters value

    Roberto,
     

    They are just stored as part of the procedure text in syscomments.

    Linda


    lindawie Guest

  3. #3

    Default Re: Default Stored Procs Parameters value

    > In which system table are stored the defaults values defined for the 
    values.

    They're not stored at all, except - as Linda noted - within the very text of
    the proc in syscomments. For more information, see
    http://www.aspfaq.com/2463


    Aaron Guest

Similar Threads

  1. Stored Procs
    By @ HOTMAIL DOT COM in forum ASP Database
    Replies: 6
    Last Post: November 26th, 12:06 PM
  2. SQL stored procs in 8.1
    By Murty in forum IBM DB2
    Replies: 4
    Last Post: August 25th, 11:21 PM
  3. Q: retrieving default values for parameters in stored procedures ?
    By Fridthjof-G in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 5th, 08:47 AM
  4. Stored Outlines For Queries In PL/SQL Stored Procs
    By Salaam Yitbarek in forum Oracle Server
    Replies: 0
    Last Post: December 5th, 01:54 PM

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