Some data is missing in the table of SQL
This is the default setting SQL Server Management Studio, Navigate on Menu button as follows

If you are using Result to Grid:

Tools --> Options --> Expand Query Results --> Expand SQL Server -- > select result to Grid

then at the right side you will see Maximum number of characters Retrieved and Non XML Data with the Text box, enter 65535(This is maximum possible value) then click on OK.

If you are using result to Text:

Tools --> Options --> Expand Query Results --> Expand SQL Server -- > select result to Text 

then at the right side you will see Maximum number of characters displayed in each Column and the Text box, enter 8192 (This is maximum possible value) then click on OK.

Note:
You need to open new Window for the changes to take effect, it will not be applicable for opened windows.