SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Partial name matching in SQL Server 2011 “Denali”

While playing with SQL Server 2011 “Denali”, I’ve accidentally found out that it has slightly enhanced intellisense in SSMS. There is one thing which I really like much – partial name matching. Prior to SSMS 2011 you had to enter object’s first letters in order to be completed by intellisense. For example to find “JobCandidate” table you had to enter “Jo … “. This was quite annoying especially if you had many objects with same prefix – this turn intellisense almost unusable. In SQL Server 2011 you can enter any part of object’s name and intellisense will still find it.

See simple demonstration here.

I am personally switched off standard intellisense in SSMS 2008 long time ago and using Red Gate’s SQL Prompt instead because it is just better. This is much more than enhanced intellisense but probably to align SQL Prompt intellisense to SSMS 2008 intellisense behavior, partial name matching is not implemented in SQL Prompt . I was googling and found out that partial name matching is in top 3 feature request for SQL Prompt. I voted :)

To complete intellisense story – I was googling for full list of SSMS 2011 intellisense enhancements and found this article.



Posted by Anonymous on 22 July 2011

Pingback from  Dew Drop – July 22, 2011 | Alvin Ashcraft's Morning Dew

Posted by Anonymous on 25 July 2011

Thomas Friedman thinks the next generation might be inventing their jobs, rather than finding them. The

Leave a Comment

Please register or log in to leave a comment.