Transact-SQL Subset

Each of the following classes of Transact-SQL statements is supported for distributed queries if the provider supports the required OLE DB interfaces.

• All SELECT statements are allowed except for SELECT INTO statements with a remote table as the destination table.
• INSERT statements are allowed against remote tables if the provider supports the required interfaces for insert. For more information about OLE DB requirements for INSERT, see “INSERT Statement” later in this chapter.
• UPDATE and DELETE statements are allowed against remote tables if the provider satisfies the OLE DB interface requirements on the specified table. For the OLE DB interface requirements and conditions under which a remote table can be updated or deleted, see “UPDATE and DELETE Statements” later in this chapter.