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"
{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
{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
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 and number of characters in place of the
"*".
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.
{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.
