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 @counter < (SELECT SUM(RowNumber) FROM @indextable)
B. WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable)
C. WHILE SUM(@RowNumber) < (SELECT @counter FROM @indextable)
D. WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable)
Answer:D
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 @counter < (SELECT SUM(RowNumber) FROM @indextable) B. WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable) C. WHILE SUM(@RowNumber) < (SELECT @counter FROM @indextable) D. WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable)