SQL Query plus (2023 edition)

** Can be used on Adventureworks.

A great tool for developers, SQL Query plus allows a user to access the tables of a database without having to use the Microsoft SQL Server Management Studio provided by Microsoft.

The advantage is that database access security can be maintained through SQL permissions while allowing the user to create custom queries quickly. The results can be exported to various file formats such as Interbase script or Firebird script. Export to clipboard is great for analysing results in a spreadsheet.

It is possible (though not recommended) to make database changes after setting 'Allow Live' to ON, after which any changes to data in the grid will be written back permanently. It would be prudent to always create a backup of the database before making any live changes - in many cases this can be done within the application that owns the database files.