As my fellow DB-Master advised me:<br>Open MS SQL7 Query Analyzer, go to Query->Current Connection Options-> Advanced Tab. Find the box Maximum Character per Column (default = 256) and put there the necessary number.<br>I published this for everybody's benefit.<br>
As my fellow DB-Master advised me:<br>Open MS SQL7 Query Analyzer, go to Query->Current Connection Options-> Advanced Tab. Find the box Maximum Character per Column (default = 256) and put there the necessary number.<br>I published this for everybody's benefit.<br>
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)) > 500 .<br>Showing the result, SQL7...
Thanks Chris, I tried to use TEXT datatype with fields up to 4000 positions and it works. 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)) > 500 .<br>Showing the result...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.