title: How can I store records with 500 CLOB fields?
body: <p>Oracle has a max column limit of 1000 and even with all columns defined as VARCHAR(4000) I was able to create the table and load huge amounts of data in all fields.<br>
  I was able to create a table in SQL Server with 500 varchar(max) columns, however when I attempt to insert data, I got the following error:   </p>
  
  <blockquote>
    <p>Cannot create a row of size 13075 which is greater than the allowable
    maximum row size of 8060.</p>
  </blockquote>
  
  <p>When I made the table 200 columns I was able to insert huge amounts of data.  </p>
  
  <p>Is there a way to do this in SQL Server?</p>