sql server studio managemenet studio cutting very long data from the field, how to get complete data ?

Export Data to a File:If you need to work with a large amount of data, consider exporting the data to a file using the "Save Results As" option. This way, you can save the complete data to a file and view it externally.