I recently learned some new things about the Search APIs in Windows Vista, including some great improvements in the SQL syntax for the OLE DB Provider for Windows Search. (Thank you Chris McConnell - Architect on the Search team - for driving these changes, and for taking the time to explain them to me!).
There've been some simplifications in the syntax that happen to address a couple of things I found to be a bit odd and cumbersome:
So, a query like this:
SELECT "System.ItemName", "System.ItemUrl" FROM SYSTEMINDEX..SCOPE()
can now be written like this:
SELECT System.ItemName, System.ItemUrl FROM SYSTEMINDEX
Much better, isn't it?
(Note that these changes reflect added flexibility, and won't break any existing queries)