Limiting the Amount of Characters Output in a Column Using the SQL TEXTSIZE Command
TEXTSIZE can limit the amount of data returned for the following data types: varchar(max)nvarchar(max)varbinary(max)textntextimage To set the TEXTSIZE use the following command: SET TEXTSIZE (number) So, if I were to