Home Forums SQL Server 7,2000 T-SQL Is there a way to get the largest row size (in bytes) from a table? RE: Is there a way to get the largest row size (in bytes) from a table?

  • January 13, 2004 at 12:00 pm

    #489813

    Wouldn't something like this be more useful?

    SELECT SUM(Length)

    FROM syscolumns

    WHERE OBJECT_NAME(Id) = 'Tablename'



    --Jonathan