This scenario is similar to the scenario in “Remote Query” except that the command text given to ICommand is a command string submitted by the user and is not interpreted by SQL Server. SQL Server uses DBGUID_DEFAULT as the dialect identifier when it calls ICommandText::SetCommandText. DBGUID_DEFAULT indicates that the provider should use its default dialect. If this command text returns more than one result set, for example, if the command invokes a stored procedure that returns multiple result sets, SQL Server would use only the first result set from the command.
For a list of all OLE DB interfaces that SQL Server uses, see “OLE DB Interfaces Consumed by SQL Server” later in this chapter.