The Data Viewer editor displays data from the SSMS results grid in the Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, and Spatial file formats.
To access the Data Viewer, use one of the following options:
In the Data Viewer editor that opens, you can use the following controls:
Load Data: Copies and loads data from a source file.
Save Data: Saves data to the user’s computer.
Copy Entire Cell Value: Copies the value of the entire cell.
Paste Entire Cell Value: Pastes the value of the entire cell.
Cut Entire Cell Value: Cuts the value of the entire cell.
Hexadecimal View: Displays data in the Hexadecimal file format
Text View: Displays data as text. When clicking Text View, the following controls are available:
View White Space: Displays white-space characters in the text.
Word Wrap: Removes the horizontal scrollbar, and lines of the text exceeding the width of the editor are automatically wrapped to the next line of the editor.
XML View: Converts data into the XML file format.
HTML View: Displays data in the HTML file format.
Rich Text View: Converts text data into the Rich Text file format.
PDF View: Converts data into the PDF file format.
JSON View: Converts data into the JSON file format.
Image View: Displays data as an image. When clicking Image View, the Fit Image control is displayed that can be used to fit the image in the view.
Spatial View - Geometry: Displays data in the flat coordinate system.
For example, let’s visualize the data from the varbinary field of the LargePhoto column of the AdventureWorks database. The Data Viewer displays it as an Image view.