Combined SET and SELECT Statements
The OLE DB provider allows you to execute one SELECT statement and one
SET statement per query. Enter a space or a line break to
indicate the end of a statement in a query. You do not need to use a semicolon (;)
at the end of the line or statement.
Use SET and SELECT Statements on the Same Line
SET samplingmode=interpolated SELECT * FROM ihquerysettingsUse SET and SELECT Statements on Different Lines
SET samplingmode=calculated, starttime=yesterday, endtime=today
SELECT * FROM ihquerysettings