nvarchar(max) column truncates data

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


LinkedIn Profile

Volunteer Expert at EE

Code Project Profile

My Code project

Stackoverflow Profile

profile for NeverHopeless on Stack Exchange, a network of free, community-driven Q&A sites

BrainBench Certified


Elance Testimonials