#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    South Africa (Deepest Darkest Africa)
    Posts
    1
    Rep Power
    0

    Question Domains in Procedures


    Hi All,

    I'm making use of stored procedures and I want the field type to be a domain.

    eg.
    At current
    THE_ID Varchar(10)
    and I want it to be
    THE_ID DOM_THE_ID

    The reason being that if I change a domain (maybe to increase is size) I don't want to go through each procedure and change is there.

    Any suggestions
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12
    - Wait for fb2 to come
    - still, you should recompile al the procedures involved
    Romania it's a beautiful country ... too bad that it's populated with ... peoples!

IMN logo majestic logo threadwatch logo seochat tools logo