The following code gives the current value of the TEXTSIZE option of the SELECT statement. This specifies the maximum length, in bytes, of varchar(max), nvarchar(max), varbinary(max), text, or image data that a SELECT statement returns and also how to set the value of TEXTSIZE property
SELECT @@TEXTSIZE AS 'Text Size'
SET TEXTSIZE 2048
SELECT @@TEXTSIZE AS 'Text Size'
|
No responses found. Be the first to respond and make money from revenue sharing program.
|