Quiz 70-451

Quiz 70-451, PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

You need to ensure that the SQL Server 2008 server places the minimum possible number of locks on the table while the stored procedure is being executed

You need to design a solution to guarantee that a stored procedure is part of every transaction

You need to minimize the number of blocking processes

You need to ensure that your result set is encapsulated within a root element

You need to design the database to meet these requirements

You need to develop a stored procedure strategy that will manipulate temporary result sets to meet the following requirements…

You need to identify the appropriate function to use

What should you include in the strategy?

You need to design the function to meet these requirements

Which SQL statement should you use?