70-464 Question 8

You execute IndexManagement.sql and you receive the following error message: “Msg 512, Level 16, State 1, Line 12 Subquery returned more than 1 value. This is not permitted when the subquery follows =, != ,<, <= , >, > = or when the subquery is used as an expression.” You need to ensure that IndexManagement.sql executes properly. Which WHILE statement should you use at line 18?

A. WHILE SUM(@RowNumber) < (SELECT @counter FROM @indextable)
B. WHILE @counter < (SELECT SUM(RowNumber) FROM @indextable)
C. WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable)
D. WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable)

Answer: D

Category: 70-464 Exam Questions

you are at 70-464 Question 8

For more questions you can browse 70-464 Exam Questions.

Recent Post