Note Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.
Batched statements allow you to set and execute SQL statements, optionally separated by semicolons ( ; ), as one command. You can batch SET statements with CREATE VIEW statements and, optionally, with a single following SELECT statement.
SET_Statement | CREATE_VIEW_Statement [ [;] SET_Statement | CREATE_VIEW_Statement ] ... [ SELECT_Statement ]
For details about SET_Statement, see SET Statement.
For details about CREATE_VIEW_Statement, see CREATE VIEW Statement.
For details about SELECT_Statement, see SELECT Statement.
The duration of batched SET and CREATE VIEW statements is the length of the session with Indexing Service.
If included, a SELECT statement must appear as the last item in the batch.
The following example represents a batched SET, CREATE VIEW, and SELECT statement.
SET PROPERTYNAME 'D5CDD502-2E9C-101B-9397-08002B2CF9AE' PROPID 14 AS MyProperty TYPE DBTYPE_STR; CREATE VIEW #MyView AS SELECT FileName, MyProperty FROM SCOPE('"/CheckIn"'); SELECT * FROM #MyView
Build date: 9/10/2012