Checking the row size

• Tony Lomas

  Newbie

  Points: 2

  More actions

  May 19, 2005 at 5:26 am

  #76314

  Hello,

  Can anyone tell me of any SQL command I can use to find out which rows have the most text in.  I'm adding a column to my table and having problems due to the maximum row size of 8k.  Is there a way that I can see which particular rows have the most text in them.

  Thanks in advance.

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 19, 2005 at 6:05 am

  #559812

  SELECT pk_column, LEN(textcolumn) AS textlen FROM tablename ORDER BY textlen DESC

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Tony Lomas

  Newbie

  Points: 2

  More actions

  May 19, 2005 at 7:36 am

  #559843

  Thank you very much.  That was exactly what I needed.