Which of the following SQL syntax elements is dictated by the SQL dialect levels ?
A. LIKE support
B. Parameter marker support
C. Nested query support
D. None of the mentioned
Answer:A
Which of the following SQL syntax elements is dictated by the SQL dialect levels ?
A. LIKE support B. Parameter marker support C. Nested query support D. None of the mentioned
Explanation:System administrator should set the NestedQueries provider option to indicate to SQL Server that the provider supports nested queries. 8. Which of the following function will be preferred for faster execution in following code ?