[Solved] Setting Varchar in sql server

Question

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!

Accepted Answer

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!