This article describes the benefits of using ApexSQL Search options for searching phrases, history, and results.
Any text string can be used as a search phrase including strings containing special or Unicode characters. There is no virtually no limit to the length of the search phrase.
The search phrases aren’t case sensitive. For instance, to search for Boston, use boston as the search phrase
In addition to plain text, wildcards can be used in search. For instance, to find all objects which contain a text starting with the letter M, search for M%.
ApexSQL Search supports the same wildcards as the LIKE operator in SQL Server. For a full list of supported wildcards and their use, visit the See also section
Search history allows users to repeat the exact used search, including the search phrase and the specified search options in a single click.
Let’s say that the searched term was admin and the Exact match option was selected. The next time when the same search is performed, simply select admin from the Search text drop-down menu; only the results that exactly match admin will be displayed:
If the same phrase is searched, but the search options (e.g. select a different database) are changed, the information message will be shown to prompt to update the saved search. If it’s chosen to do so, the saved search options will be overwritten with the new ones
The results of interest can be quickly identified by:
- Sorting the result set by column. By default, search results are sorted by Name in a descending order. To change the sort order or sort by a different column, simply click the appropriate column name
- Filtering out unwanted results via the Filter row feature:
For example, to show the results found in both AdventureWorks2014 and WideWorldImporters databases for selected SQL Server instance, select the All databases option from the Database combo box prior to searching:
After the results are shown, click the Filter button in the Database column, switch to the Text filters tab and type 2014 or Wide for the First and Second value fields:
ApexSQL Search supports .NET framework regular expressions. For more information on how to search for text using regular expressions, visit the See also section
November 20, 2014