Are you tired of typing long SQL statements and searching for database objects manually? Look no further! In this article, we will introduce you to ApexSQL Complete, a free SQL Server Management Studio and Visual Studio add-in that will revolutionize your SQL coding experience.

Hint list – complete your SQL code

One of the key features of ApexSQL Complete is its powerful intellisense functionality. Instead of typing the entire object name or keyword, ApexSQL Complete helps you find the desired object or SQL keyword and completes the SQL statement for you. Simply start typing and the intellisense will appear with a list of keywords and database objects that match your input. You can even customize the intellisense list by unchecking the boxes for objects you don’t want to appear.

Tab navigation – monitor all opened SSMS tabs

Have you ever lost track of your opened tabs in SQL Server Management Studio (SSMS)? With ApexSQL Complete, you can easily track and manage all your opened and recently closed tabs. The Tab navigation feature allows you to switch between tabs, search the content of queries, and even restore previously saved sessions after a crash. This feature saves you time and ensures you never lose your work again.

Code structure – view and find SQL code blocks

When working with large SQL scripts, it can be challenging to navigate through the code and find specific parts. ApexSQL Complete’s Code structure feature provides a tree-like view of your SQL code, allowing you to easily navigate to specific blocks. By selecting an item from the Code structure window, the corresponding SQL code block will be highlighted in the query window. Say goodbye to endless scrolling!

Executed queries – track your SQL history

Ever wondered what queries you executed in a specific time period? ApexSQL Complete’s Executed queries feature allows you to track all executed queries within a defined period. You can even set a folder to store the executed queries as XML files. This feature is especially useful for auditing and troubleshooting purposes.

Snippets library – insert frequently used SQL statements

Do you find yourself repeatedly typing the same SQL statements? ApexSQL Complete’s Snippets library feature comes to the rescue! You can create snippets for often used SQL statements, procedures, or blocks of code. You can even import and export snippets for use on different machines. Say goodbye to repetitive typing and hello to increased productivity!

Navigate to object – locate objects in Object Explorer

Have you ever needed to quickly locate an object in the Object Explorer pane? With ApexSQL Complete, you can easily do so. Simply select the object in your query window, right-click, and choose the Navigate to object option. The selected object will be located and highlighted in the Object Explorer pane, saving you time and effort.

Test mode – execute queries without impacting the database

Worried about executing queries that might have unintended consequences on your database? ApexSQL Complete’s Test mode feature allows you to execute queries in a test environment without any impact on the actual database. By selecting the Test mode option and highlighting the SQL code you want to execute, ApexSQL Complete will automatically add BEGIN TRANSACTION and ROLLBACK TRANSACTION statements. This ensures that any changes made during the test execution are rolled back, keeping your database safe.

ApexSQL Complete is a powerful tool that enhances your SQL coding experience by providing intelligent features and streamlining your workflow. Download ApexSQL Complete today and take your SQL Server development to the next level!