Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2007
    Location
    Maryland, USA
    Posts
    8

    Unanswered: How can I change decimal length from 9 to (16,3)

    I am not sure wht the tsql is for changing a decimal data length form 9 to (16,3)
    Thank you

  2. #2
    Join Date
    Dec 2008
    Posts
    135
    alter table tablename alter column columnname decimal(16,3)

  3. #3
    Join Date
    Jul 2007
    Location
    Maryland, USA
    Posts
    8

    Is culumn decimal 9(16,2) correct?

    Thank you so much, it has changed most of the culumns and in query analyzer the length of culumns are what I wanted, however when I check the properties of the culumns under "enterprise manager"itself, the length property still shows cramt decimal 9(16,2) instead of size of cramt decimal(16,2)
    Is that Ok or shall I alter it again?
    Thanks for the help

  4. #4
    Join Date
    Dec 2008
    Posts
    135
    no problem
    it is lenght prec scale
    9 16 2
    no need to alter u tablecolumn again

  5. #5
    Join Date
    Jul 2007
    Location
    Maryland, USA
    Posts
    8

    Thank you!

    I appreciate the help

  6. #6
    Join Date
    Dec 2008
    Posts
    135
    ur welcome

Posting Permissions

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