Skip to main content

dbForge SQL Complete: Auto completion on MS SQL Server 2005

When coding on MS SQL Server Management Studio, if your management version is 2008 or later, you have auto completion function. But working on MS SQL Server Management Studio 2005 or earlier, you must code without that function. dbForge SQL Complete can help you.


Feature:




  • Code completion: provide available keywords, object names, code fragments

  • Statement expansion: expands full code templates for every statements (SELECT, DELETE, UPDATE)

  • SQL snippets: dropdown promt list which contains availabe code template for you

  • SQL formatter: take care of the formatting text for you

  • Quick object infomation: display an information box when hover on an object

  • Code navigation: support go to object's definition on text editor

  • Also support Microsoft Visual Studio


How to use:




  • Download dbForge SQL Complete free here > Choose Express version

  • Install it normally










  • And try it



Wish succeed!

Comments

  1. buy wedding dresses's a I very much hope, I hope your life more wonderful post.

    ReplyDelete
  2. Thanks you, @bridal jewelry!
    I browsed your site. It will useful for me in the future. :D

    ReplyDelete
  3. The SQL standard names are LOWER and UPPER, not LCASE and UCASE. Some prdtucos like MySQL alias LCASE and UCASE to the LOWER and UPPER functions for increased compatibility with other non-standard prdtucos and some prdtucos that are not databases. MS Access uses LCASE and UCASE as does the non-database prdtucos Excel and OOCalc. There are some programming languages which use LCASE and UCASE. There may be other DB prdtucos that do not use the SQL standard LOWER/UPPER names for these functions. Oracle does use LOWER/UPPER. DB2 supports both. PostgreSQL uses LOWER/UPPER.

    ReplyDelete

Post a Comment

Popular posts from this blog

Turn off AutoPlay on Windows

On Windows, when you insert an USB or a CD/DVD into your computer, they are usually opened automatically. So the computer maybe infected autorun virus. To avoid that, you should turn off AutoPlay function.

Create Wordpress page template

When creating a new page in Wordpress, we usually have a choice for the page template. It's call Default template . However, we sometimes need to make a new page with a new appearance. Then another page template is needed. Instead of downloading a shared page template from internet, we can create a new page template by below instructions.