I have table with a column having nvarchar(max) type.data stored in that column having more than 1.5 lakh character width. But while i select this column using simple select query it could not show the string stored in that column . only shows string with width lesser than actual. but i checked the length of the data stored in the column ,it shows correct length. please help me if there any method to select entire string
This is a limitation of SSMS. You can change how many characters are displayed by Query -> Query Options and then Grid tab or Text tab as the case may be and setting the max number of characters to be displayed. But there is a max limit to what you can set it to. 65535 for grid and a lower number of text.