Home Forums SQL Server 2008 T-SQL (SS2K8) declaring datatypes RE: declaring datatypes

  • July 26, 2010 at 10:25 am

    #1198291

    How are you going to name this column?

    If it's Comments then varchar can be used.

    If it's intended be "Details", then follow Gail advise and split it into separate columns, for example:

    SomeCode CHAR(4),

    AnotherCode CHAR(8),

    Amount DECIMAL(19,6),

    CurrencyCode CHAR(3)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]