SQL SERVER – How to Survive on Free Tools for Month – ApexSQL Complete – A Free SQL Advanced Intellisense

SQL
7 Comments

ApexSQL Complete is a free add-in for auto-completing SQL code which integrates with SQL Server Management Studio and Visual Studio. Let us learn about free tools for the month.

The auto-complete feature recognizes, and predicates SQL keywords as well as objects, schemas, databases, parameter and variable names. To auto-complete SELECT statement in a single click just type the SELECT statement into the query window and check the column in the hint list. The rest of the statement will be auto-completed.

SQL SERVER - How to Survive on Free Tools for Month - ApexSQL Complete - A Free SQL Advanced Intellisense apex1

By highlighting the object in the hint list you’ll get the complete DDL statement of the selected object even if it is encrypted.

Using the Insert full INSERT statement option you can get the full INSERT statement for a table, without being bothered to remember the order of values you need to pass and the need to write out all the columns. Simply type the INSERT statement in the query window and select the wanted table from the hint list.

The Insert Procedure Parameters Automatically options automatically to display input parameters of the stored procedure in the correct order, and to schema qualify object names automatically use the Insert Object Owner option.

SQL SERVER - How to Survive on Free Tools for Month - ApexSQL Complete - A Free SQL Advanced Intellisense apex2

ApexSQL Complete also has user friendly Snippets feature with various variables. I’ll show the snippets feature with a simple example using the $PROMPT$ variable, and make another way to complete statements in the query window.

Create a snippet or edit the existing one in the snippets dialog.

SQL SERVER - How to Survive on Free Tools for Month - ApexSQL Complete - A Free SQL Advanced Intellisense apex3

From the query window, right-click and choose the ApexSQL Complete Insert Snippet command. Select the snippet from the hint list, and in this case, because we’re using the $PROMPT$ variable it will prompt the Column Dialog we created.

SQL SERVER - How to Survive on Free Tools for Month - ApexSQL Complete - A Free SQL Advanced Intellisense apex4

Enter the variable name, in this simple example the column name and click Ok. The rest of the statement will be inserted and you will be prompted with the hint list for choosing the table to complete the FROM clause

ApexSQL Complete is a SQL intellisense that has more useful options and commands such as:

  • Choose the Error list feature to get a list of all syntax errors, updated in real-time
  • Use Hints feature to expand or narrow the auto-complete hint list
  • With the Code structure feature to display the internal structure of your code
  • Create your own aliases or use auto created aliases. Custom table alias will replace the auto created one and it’ll be listed in the hint list
  • Add alias or object name to the columns in the WHERE clause, even if there is only one object is specified in the FROM clause, and many more

If you’re looking for a tool that can make your coding process faster and easier and within your budget, try out this free SQL assistant by ApexSQL

Reference: Pinal Dave (https://blog.sqlauthority.com)

,
Previous Post
SQL Contest – USD 100 Gift Card and Attractive Discount from Devart
Next Post
SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007

Related Posts

7 Comments. Leave new

  • I love the functionality in ApexSQL Complete, but even the latest version causes my SSMS (2012) to crash several times per day and I just can’t live with that so I have to uninstall it. Every few months I try the latest version, but get the same result.

    Reply
    • Yes, I liked ApexSQL Complete functionality, but constant crashes on SSMS 2012 forced me to uninstall. I use dbForge SQL Complete and SSMSBoost.

      Reply
    • I haven’t had crashing issues in SSMS 2014. Used it for about a week. It does occasionally freeze up for one or two seconds when it’s building the completion list. Quite annoying but well worth the wait. The helpers for joins are quite wonderful.

      Reply
    • Hi

      I’ve been using the latest versions of ApexSQL Complete for a year or more, it constantly crashes SSMS if it can’t find the connected database. We drop and recreate databases all the time and also connect to remote databases via VPN that we start and stop as required. If ApexSQL Complete can’t find the database it wants, it just crashes and brings SSMS and all your unsaved work with it. I have to use SSMS Tools to ensure I can get my work back.

      I’ve notified ApexSQL of the issues and supplied them with my log files in the past, but the crashes continue to plague me. I would be okay if the ApexSQL Complete plug-in just crashed, but why it has to kill SSMS as well just baffles me.

      Cheers
      Craig

      Reply
  • Hi,

    We in ApexSQL are fully aware of the issue and we fixed it for our next release. To get the pre-release please send an email to support@apexsql.com. We’ll be glad to send you a link

    You can also connect with me on Twitter to get updates on ApexSQL tools – @SQL_MiM

    Thanks

    Reply
  • andreirantsevich
    December 20, 2013 5:29 am

    Hello Dave,
    it would be nice if you give a chance to SSMSBoost project. You have mentioned it on twitter 1.5 years ago, maybe it’s time now for a blog post ;) We have currently reached 6500 users, using free version. I can support you with any information you need. Your posts look pretty independent, so I hope there will be a place for us as well. For any questions you can get in touch with me.

    Sincerely yours,
    Andrei

    Reply
  • Hi,

    The release of ApexSQL Complete R4 with a fix for SSMS crashing issue, and 50% better performance is out

    You can download individual installer from our download page

    For any issues feel free to contact ApexSQL directly on support@apexsql.com

    Thanks

    Reply

Leave a Reply

Menu