SQL Azure Query Builder
RazorSQL includes an SQL query builder for SQL Azure that gives users the ability to easily create SQL select, insert, update, and delete statements. Users can also build multi-table join select statements. The query builder provides drop down boxes and check boxes to make it easy for users to select column names to populate, conjunctions to use, data to enter, etc.
The SQL Azure query builder contains 5 tabs, a tab for each of the following types of SQL statement: Select, Insert, Update, and Delete. It also contains a Search tab that will generate a select statement based on search criteria entered by the user.
The select tab of the SQL Azure query builder allows users to easily select data from tables. Users can check which columns to return in the select statement, and build the SQL select where clause by selecting the appropriate operators and column values. Users can also add other tables to create join statements.
The insert tab of the SQL Azure query builder allows users to quickly insert data. Users can select which columns to include in the insert statement, and the corresponding data for those columns.
The update tab of the query builder allows users to select which columns to update, and what columns and values to include the SQL update where clause.
The delete tab of the SQL Azure query builder has options for users to quickly identifier the where condition by which to delete data.
For more information on the query builder, see the following documentation:
SQL Query Builder
RazorSQL also offers many other SQL Azure tools such as a database browser, GUI tools for managing objects and structures, and much more. See the main SQL Azure Features Page for more information.