14 DAY TRIAL // The Search team working on Windows Vista has enhanced the Search APIs in the operating system. The SQL syntax for the OLE DB Provider for Windows Search was the stage for syntax simplification.
"System property names no longer require double quotes. Recall that the column names specified in the SELECT statement must be properties from the Windows Vista property system; and since the naming convention for properties includes dots (System.Application.Property), property names had to be delimited with double quotes. The double quotes are no longer necessary for system-defined properties (the ones that begin with System)," stated Catherine Heller, Microsoft Technical Evangelist.
Additionally, Microsoft has shredded the SCOPE() that was necessary in a FROM statement to point to the location of the search. "There is only a single catalog that can be searched on the desktop - and since scope is actually defined using the "Scope=" predicate in the WHERE clause - you no longer need to add that funky "..SCOPE()" stuff at the end of the FROM clause," added Heller.
In this context, a query such as: SELECT "System.ItemName", "System.ItemUrl" FROM SYSTEMINDEX..SCOPE() is now: SELECT System.ItemName, System.ItemUrl FROM SYSTEMINDEX.