![]() ![]() This could be useful if, for any reason SSMS crashes. Here you can set the period for keeping the tabs saved, and set the interval for auto-save. These operations can be managed from the add-in options, under the Tab navigation tab. This feature allows you to track opened and recently closed tabs, or to restore previously saved session after crashing. Tab navigation – monitors all opened SSMS tabs Releasing the CTRL key will get you back to a previous state, and you can continue typing: Press and hold the CTRL key, and the SQL intellisense will become transparent, so you can see through, and review SQL code. ApexSQL Complete offers you to accomplish this without a break. If a SQL script you are using is large, at some point you will need to look at SQL code before you continue. You can also select the columns and hit the Enter key to insert them: This will decrease the number of hints in the SQL intellisense list, and speed up the coding process:Īnother useful property of the SQL intellisense in ApexSQL Complete is a multiple sections, which allow you to navigate over the database schema, to a table, and select the specific columns, checking the appropriate boxes. ![]() You can uncheck the box for the appropriate objects, and prevent them to appear in the SQL intellisense from the add-in options, under the Hints tab. After you start typing, for example “SE”, SQL intellisense will appear with all keywords and database objects that contains “SE”, listed by importance: It helps you find the wanted object or a SQL keyword, and complete the SQL statement faster instead of typing the entire object name or keyword. ![]() This is a key feature of ApexSQL Complete. ![]() To start using ApexSQL Complete, enable it from the ApexSQL menu under the main menu in SSMS: In this article, we will explain ApexSQL Complete through its features. You can download ApexSQL Complete, and play along through the article.ĪpexSQL Complete is a free SQL Server Management Studio and Visual Studio add-in that speeds up SQL coding. This article shows how to use ApexSQL Complete, a free intellisense add-in. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |