![]() ![]() It is easy for database developers to rename a database object without any risk of losing reference in other dependent objects using SQL Assistant refactoring tool.Writing queries to a database requires knowledge about SQL syntax, but this is not all you should know. In the second step of refactoring process, the code places where will be changed by refactoring tool is displayed as follows. Using this sql tool for refactoring, database professionals can set a new name for the database object in the first step of refactoring process.Īnd in the second step, the refactoring tool will list the database objects that will be affected by the name change and with your approval alters the dependent objects to use the new object name for reference.įor example, in the following screenshot I just change the input parameter name of a SQL Server split function for demonstrating refactoring in SQL Server with SQL Assistant tool ![]() SQL developers and database administrators can easily rename a database object like a stored procedure, a user defined function using SQL Assistant refactoring tool. One of the most important features of SQL Assistant tool for SQL Server is its refactoring capabilities in SQL Server. Rename Stored Procedures or any SQL Object using SQL Server Refactoring Tool To format sql code will also bring a sql code standardization to development teams building applications on SQL Server databases. Just pressing Ctrl+F11 key combination on the SSMS query editor screen or following the menu options "SQL Assistant > Format Code > Format", sql developers can easily make sql code more readable so understandable. 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. SQL Assistant SQL Formatter tool for SQL Server Database Developers
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |