What are the challenges you face when working across database platforms? Take the survey
Options

Exact match confusion with object names and square brackets

kevrileykevriley Posts: 129 Gold 1
edited September 9, 2015 4:19AM in SQL Search
Against a copy of AdventureWorks2008R2, search for

[EMP_cte].OrganizationNode

with 'Exact match' unticked : this returns 2 results uspGetEmployeeManagers and uspGetManagerEmployees, and highlights the code accordingly (even though the code actually uses [] around the object names - this is a Good Thing.

Now tick 'Exact match', and although the results are the same, there is now no highlighting


Using SQL Search 2.0.1.28, in SSMS 2008R2 (10.50.4000.0), against a SQL2008 database (compat level 100)

Comments

Sign In or Register to comment.