Archive for

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

Copy one database table rows to another database table

It is a common practice in IT industry that organizations manages data in different databases for different departments. For example a company has a Quality assurance database and a developer database. But they faces an issue when they need a record from some database to their database. In that case, IT person needs to write … 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