Point out the wrong statement :
A. SQL Server cannot use execution strategies that involve using the procedures of the Table provider to evaluate predicates.
B. For a distributed query, the comparison semantics for all character data is defined by the character se
C. SQL Server can delegate comparisons and ORDER BY operations on character columns to a provide
D. None of the mentioned
Answer:A
Point out the wrong statement :
A. SQL Server cannot use execution strategies that involve using the procedures of the Table provider to evaluate predicates. B. For a distributed query, the comparison semantics for all character data is defined by the character se C. SQL Server can delegate comparisons and ORDER BY operations on character columns to a provide D. None of the mentioned
Explanation:SQL Server can use execution strategies that involve using the indexes of the Index provider to evaluate predicates and perform sorting operations against remote tables. To enable indexed access against a provider, set the IndexAsAccessPath provider option.