//
archives

Retrieve more than 65535 characters from SQL columns

This tag is associated with 1 post

Retrieve more than 65535 characters from SQL varchar/nvarchar column


Few days ago, I was stuck in a problem to retrieving data from “varchar(max)” column. The data in the column was more than 30k characters. I realized that we can not retrieve more than 65535 characters from the column using this “regular” statement: Select * from TableA   See how it works in sql: In order … Continue reading