Home » Microsoft » 70-469 » What should you add to usp_SelectSpeakersByName?
You need to modify usp_SelectSpeakersByName to support server-side paging. The solution must minimize the amount of development effort required.
What should you add to usp_SelectSpeakersByName?
A. A table variable
B. An OFFSET-FETCH clause
C. The ROWNUMBER keyword
D. A recursive common table expression
Correct Answer: B
Explanation/Reference:
Explanation:
http://www.mssqltips.com/sqlservertip/2696/comparing-performance-for-different-sql- serverpaging-methods/
http://msdn.microsoft.com/en-us/library/ms188385.aspx
http://msdn.microsoft.com/en-us/library/ms180152.aspx
http://msdn.microsoft.com/en-us/library/ms186243.aspx
http://msdn.microsoft.com/en-us/library/ms186734.aspx
http://www.sqlserver-training.com/how-to-use-offset-fetch-option-in-sql-server-order-byclause/- http://www.sqlservercentral.com/blogs/juggling_with_sql/2011/11/30/using-offset-and-fetch/