SQL studio 2.0: New Version released

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