//
archives

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