Search Syntax Examples

Master the power of advanced search with boolean operators and wildcards

Pattern Order By
Matches: 
ORDER BY ProductReleaseNoteID DESC
order by ProductID, LicenseType_SortOrder
Notes:

Implicit curly brackets enclose the search text entered. This expression is treated as a search for the string "Order By"

Pattern {Order} AND {By}
Matches: 
CALL spGetWorkOrderByEmployeeDate;
Line 12: CREATE PROCEDURE [spGetProductByCode]
Line 49: SELECT Order_Date
Notes:

Boolean operators "OR", "AND" and "NOT" are only recognized when search terms before and/or after the keywords are explicitly enclosed within curly brackets

Pattern {insert} and {{into} AND {{Order} OR {Customer}}}
Matches:

(with "Exact" filter on, "Case Sensitive" off)

INSERT INTO [Customer]
Line 43: IF(NOT EXISTS(SELECT * from [Order] WHERE OrderID= @OrderID))
Line 51: INSERT INTO
Notes:

Boolean operators "OR", "AND" and "NOT" are not case sensitive. The default order of operations is left to right unless grouped by additional curly brackets

Pattern h*s
Matches: 
-- This stored procedure Checks to see if a license has been revoked
Shared booleanvar HasCharges := {spGetInvoice;1.Charges};
, HearAboutUsFrom_Desc AS [Heard about us from]
Notes:

Search on word boundaries, starting with the letter "h" and ending with "s", 0 or any number of characters in place of the "*".

Pattern h*s*
Matches: 
-- This stored procedure Checks to see if a license has been revoked
Shared booleanvar hasCharges := {spGetInvoice;1.Charges};
, HearAboutUsFrom_Desc AS [Heard about us from]
Notes:

Search on word boundaries, starting with the letter "h" followed by any number of characters then the letter "s", then 0 or more characters to end of the word.

Pattern {Order*_FK} OR {User}
Matches: 
SELECT Order_OtherTableID_FK
    ,Order_Total
    ,Order_Date
    ,Order_CustomerID_FK
    ,User_FirstName
    ,User_LastName
FROM
    [Order],
    [User]
Notes:

Boolean operators "OR", "AND" and "NOT" are only recognized when search terms before and/or after the keywords are explicitly enclosed within curly brackets

Please enable JavaScript to get the best experience from our site.