All found data in the results grid will be highlighted:
This feature searches through the results grid to find text that is set in the Search term box. This will find and select the database object in Object Explorer:Īnother search feature that comes with SQL add-in is the Results search feature. Right-click on the name objects in a query tab and, from the right-click context menu, choose the Navigate to object command. The Navigate to object feature finds database objects in Object Explorer from the query tabs. In the Go to object grid, the search results for that phrase will be listed:ĭouble-click on an object from the list of results, and that object will be selected in Object Explorer: In the Search box, enter the name of the object that you want to find. In Object Explorer, select a database, from the ApexSQL Complete menu, choose the Go to object command, the Go to object window will appear. To quickly find an object in Object Explorer from a particular database, the Go to object feature can be very handy. This feature also has the ability to retrieve unsaved SQL query scripts after SSMS/VS crashes, a lot of work can be saved from losses with this feature: The Tab navigation feature saves opened/closed tabs, reviews, and re-uses the closed tabs. This feature searches for Select, Update, Insert, Delete, Exec, Truncate or alter SQL statement in the SQL query tab and use these keywords, to set a new name for a SQL query tab:
One more ApexSQL Complete feature that can help in navigation between query tabs is Automatic tab renaming which analyzes the code inside the SQL query tab. The ApexSQL Complete Tab coloring feature provides custom connection color to a query tab which helps with continuous work on many different servers and databases simultaneously by giving them a better overview of which connection they are currently using: When working with a lot of opened query tabs with a lot of different SQL Server instances, it becomes hard to see which query tab belongs to which SQL Server instance. Creating the T-SQL code snippets that insert predefined SQL fragments and replaces variables with context-specific values to generate SQL can save a lot of time: This feature is useful when working with repetitive SQL code. One more feature that can speed up coding is the Snippets feature. When executing the SQL code, the Execution alerts feature analyzes the SQL code against a defined set of rules with the ability to block query execution and produce a warning message: To eliminate that possibility, use the Execution alerts feature. For example, a SQL query has a Delete statement without a Where clause, when executing such a query, the entire table will be wiped instead of only one row.
To prevent accidental data loss from executing a query. Right-click on a table and from the context menu choose the Create CRUD procedures command: ApexSQL Complete has the Create CRUD procedures feature that automatically creates Select, Insert, Update, and Delete stored procedures using customizable templates. Often used operations when working with a database are CRUD (Create, Read, Update, and Delete) operations. All executed queries can be re-used with a double click on a desired query from the list: With this feature, the content of executed queries can be searched and reviewed. Once enabled, the hint list appears, offering a hint to complete keyword, SQL fragment, or even entire SQL statement each time when begin to type SQL code in the query editor:Īnother useful feature is the Query history feature which keeps track of all executed queries. By default, this option is enabled and can be found under the ApexSQL Complete menu: The code completion (auto-complete) feature is one of the main features of ApexSQL Complete for speeding upcoding. It determines object interrelationships within the database and allows customization of the resulting SQL dependency diagram appearance:ĪpexSQL Complete is a SQL add-in that integrates into SSMS and VS, which speeds up coding by automatically completing SQL code statements, filling in SQL code fragments, keeps track of all executed SQL queries, keeps track of all query tabs, creates CRUD procedures, searches through query results, exports query result, colors query tabs and more.
All objects from the SQL Server database are present with different shapes and colors to improve their visual look and readability. This is the graphical SQL dependency viewer. This article provides guidelines to make developers’ and DBAs’ working days a little bit easier with using ApexSQL Fundamentals Toolkit for SQL Server packet.