Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Sapit
  • Content: Threads
  • Order by date
  1. Sapit

    TEXT data does not show in full - possible to reverse truncating?

    I used TEXT datatype for large fields up to 4000 positions that I put into MSSQL7. However, MSSQL7 does not show large columns in full, if a SELECT Query is performed. I did: <br>Select MyColumn from MyTable where Len(convert(varchar(8000), MyColumn)) &gt; 500 .<br>Showing the result, SQL7...
  2. Sapit

    Can change default row length?

    While creating a table in MSSQL7 with varchar(1000) fields, I received a message that the total length of a row is 14678, that exceeds the default value of 8080. Hence, the rows of date that would ne longer than 8080, will NOT be inported into my table. Where in SQL7 can I find that default row...

Part and Inventory Search

Back
Top