![]() I'm happy to find this SQL Server tool for sql format within my t-sql codes. I remember I formatted every field in the select part and formatted every table in the from clause, join columns, where clauses, etc to make the sql code readable. The most important feature for me in this SQL tool for SQL Server, is sql formatting function of the SQL Assistance.īecause as I said I had experienced many times situations where I had to understand how a sql script is build before understanding what is it doing. You have a sql SELECT statement with column names and tables are completed by this SQL Server intellisense tool. You mark the checkboxes beside the column names then that is all. The first feature of this SQL Server tool is the intellisense support while you develop your t-sql code in the SQL Server Management Studio IDE.Īlthough, SQL Server 2008 and later has build-in intellisense support for transact-sql development but SQL Assistant impressed me with its features.įor example, when you write "SELECT" then a list of tables is displayed and when you click on the table name the table columns are listed. T-SQL developers can have an idea about the SQL Assistant by just looking at the menu selections in the SQL Server Management Studio IDE.Ĭode snippets, SQL syntax check, format code, refactoring, test data generation, unit test, compare code are all very useful features of this SQL Server tool.Īll these features will definitely add to sql development quality and speed for a rapid database application development. If you want to download SQL Assistant, you can download it from Brothersoft The installation process is short and simple.ĭuring the installation you choose Add-in options to add this sql tool as an add-in to other database development applications and management tools like SQL Server Management Studio, Microsoft Visual Studio, MS Access, etc. So SQL Assistant tool for SQL is supporting all well known database products, and is a simple to use and yet powerful database tool. In fact database developers can this database development tool not only for SQL Server but for Oracle, DB2, MS Access, MySQL, etc.Īlthough I gave sample screenshots from SQL Server, I'm also using this sql tool on Oracle 10g Express with PL/SQL Developer from Allround Automations. SQL Assistant is a SQL Server tool from SoftTree Technologies. I ended to suffer from unformatted sql codes within hundreds of lines of t-sql code in stored procedures with SQL Assistant SQL Server tool. I believe many sql developers searched for a formatting sql code tool. Using SQL formatter tool for formatting sql code is very important to make sql code reading easier. To trim spaces (leading and trailing) SQL text right-click the selected text or end of string and click Format -> Trim spaces on the context menu.SQL Assistant SQL Formatter tool for SQL Server Database Developers To uncomment a commented block of text, you can either manually remove the commenting syntax or select the same block of text, right-click it and click the same item on the context menu or press the same button combination. To comment out a block of text, select the text, then press Ctrl+Shift+/ or right-click it and click Format -> Toggle Block Comment on the context menu. To uncomment a commented line, manually remove the commenting syntax, or press the same button combination, or right-click the line and click the same item on the context menu. To comment out an SQL line, press Ctrl+/ or right-click the line and click Format -> Toggle Line Comment on the context menu. To format a script to upper or lower case, highlight the SQL text, then right-click it and click Format -> To Upper Case / To Lower Case, respectively, on the context menu. To format an SQL text, select it and press Ctrl+Shift+F or right-click the selected text and click Format -> Format SQL on the context menu. How to set a variable if dbeaver.ini is read-only.Importing CA certificates from your local Java into DBeaver.Connecting to Oracle Database using JDBC OCI driver. ![]() Windows Silent Install License management.Installing extensions - Themes, version control, etc.Configure Connection Initialization Settings.DBeaver Desktop Documentation General User Guide
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |