Operate with data in multiple ways

Last modified: October 28, 2024

SQL Complete helps the user search, copy, and visualize data represented in the SSMS Results Grid, and work with this data in a variety of ways.

  • Data visualization: Data visualization allows viewing and analyzing data easily and efficiently.
  • Data search: With the robust data search functionality, the user can search data across the results grid without having to write queries to refine results (for example, using the LIKE operator).
  • Data copying: It is easy to copy data from a cell or an entire table in the results grid to a file or clipboard in the CSV, XML, HTML, and JSON formats.
  • Generation of scripts from the results grid: Users can generate scripts directly from the results grid, for example, INSERT and UPDATE statements, INSERT statements to insert data to a temporary table, and lists for WHERE clauses.
  • Data aggregation: Data aggregation is designed to help calculate sums and average values in the received data sets which is far quicker and simpler than use spreadsheets for the same purpose.

Video tutorial

Watch the following video and learn how to perform various operations with data in SQL Complete.