Introduction
SQL studio is a lightweight and running tool. the SQL Execution tool on the. NET platform, which uses the same method to create databases for multiple databases (currently supports SQL Server, MySQL, and MS Access 2007 databases ).
SQL Studio provides a series of extension commands to create database connections and other operations.
SQL studio performs semantic conversion on some SQL commands to make them closer to daily operations. For example, in SQL studio, select a table name and click execute. It will be interpreted as select Top 100 * from [Table] instead of being executed as a stored procedure.
Major updates of Version 2.0:
1. Rewrite the interface with WPF
2. List the databases accessible to the current connection.
3. log output Modification
4. When an SQL statement generates multiple datasets, multiple datasets are displayed in one tab.
5. Right-click the database element tree and provide operations such as viewing scripts.
6. multi-database support is now easier to expand
SQL maxcompute studio 2.0
Figure 1 Main Interface
Figure 2 create connection dialog box
Figure 3 effect of creating a connection command and creating a connection
Figure 4 Create a script for an SQL Server database element (tables, views, functions, and stored procedures)
Figure 5 "execute" a word, meaning changed
Download:
SQL studio 2.0 green installation-Free Edition
RelatedArticle:
SQL Studio 1.0: a lightweight SQL script tool-compatible with SQL Server, MySQL, and access2007