An SQL Server Query analyzer option...

Occasionally, a strange problem is that during data insertion, the data cannot be completely inserted into the data table and is always truncated ". The executed SQL statement is as follows:

Insert Test (recv_data) Values ( ' Bytes ' )

The data type of the recv_data field is set to varchar (2048), but the inserted data is less than 300 characters. After each insert into operation, the data obtained by the query analyzer is always incomplete. After a long time, I found out that xuanjicang was not "truncated" during data insertion, but intercepted during query display. After reading the following picture, I may understand it.

Haha ~~~ This is what is displayed on the options result page of the query analyzer menu: tool -->, this is because the query analyzer imposes a limit on the maximum number of characters in no columns when outputting the query and analysis results, which leads to the so-called data truncation.