SQL Server Performance

Column Size

Discussion in 'General DBA Questions' started by danny123, Jan 2, 2007.

  1. danny123 New Member

    Is there any function which can give me the exact size in bits of a particular column entry.Not the size of column but the perticular value entered in that column.

    Thanks
    Danny
  2. MohammedU New Member

    DATALENGTH
    Returns the number of bytes used to represent any expression.

    LEN
    Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks.

    COL_LENGTH
    Returns the defined length (in bytes) of a column.



    Mohammed U.
  3. danny123 New Member

    Thanks alot !!!

    Best
    Danny

Share This Page