Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    134

    Unanswered: Default Field Value?

    Is it possible to change the default value of a field using a stored proc or query? Any hints on how to do this if it is possible would be appreciated!

    Mike B

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Just supply the new value on the INSERT?

    Or to permanently change it you need to use ALTER TABLE...I think...gotta check...go look up ALTER in Books Online (BOL)

    OK?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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