[Solved] Setting Varchar in sql server


The issue looks that the insertion should be a success but while retrieving through the QA, you see only 255 characters back. This is just a visual problem and nothing more. Just change this limitation under the Tools > Options > Results in the SSMS where you have an option to change the Maximum characters per column option. Try changing to the desired value. Hope this helps!

solved Setting Varchar in sql server