Q. Why can't I access more than 4K of data in a TEXT field in SQL Server?
為什么TEXT字段不能存取大于4K的數據？
A. Probably because you haven't set the TEXTSIZE parameter. SET TEXTSIZE <n>
Specifies the size, in bytes, of text data to be returned with a SELECT statement. If you specify a TEXTSIZE of 0, the size is reset to the default (4K). Setting TEXTSIZE affects the global variable @@TEXTSIZE. The DB-Library variable DBTEXTLIMIT also limits the size of text data returned with a SELECT statement. If DBTEXTLIMIT is set to a smaller size than TEXTSIZE, only the amount specified by DBTEXTLIMIT is returned. For more information, see Microsoft SQL Server PRogramming DB-Library for C.
