Kris van der Mast

Kris van der Mast

Loves technology, mainly focussed on Microsoft tech. Founded VaHa bv. Microsoft MVP since 2007, Azure Advisor, aOS ambassador. Frequent speaker at and organizer of various national and international events.

Maximum number of characters displayed in each column

- less than 1 minute read

I was unaware of this at first, which gave me some frowns on my face when I found out the hard way, but results in SQL Server Management studio are truncated to a certain amount of characters. Normally you won’t notice this but when a certain line exceeds that amount you’ll notice the truncated text. I experienced it while concatenating several columns casted as varchars.

By default the maximum amount of characters is 256 but you can easily edit this setting by going to ToolsOptions. There you set a higher number of maximum displayed characters in the right lower corner of the screen when you navigate to Query resultsSQL ServerResults to Text (/images/or to Grid):

Grz, Kris.Recenet

kick it on DotNetKicks.com

Leave a Comment

You May Also Enjoy

Reading feather files in Power BI

- 2 minute read

Now that we know how to set up our local virtual environment and install the required packages, we can start reading the feather file in Power BI. First act...

Using Python in Power BI

- 2 minute read

In the former blog post we set up the virtual environment for Python in Power BI. In this post, I will show you how to use Python in Power BI. To check Be ...

Setting up Python for Power BI

- 2 minute read

It is possible to use Python in Power BI. This is a great feature because it allows you to use Python scripts to manipulate your data. In this post, I will s...

Setting up a virtual environment in Python

- 3 minute read

Intro Python knowns the concept of virtual envirnomnets. A virtual environment is a self-contained directory tree that contains a Python installation for a ...