You create a stored procedure that retrieves all of the rows from a table named Table1. You need to recommend a solution

Post by **answerhappygod** » Mon Oct 17, 2022 4:50 pm

You create a stored procedure that retrieves all of the rows from a table named Table1.
You need to recommend a solution to ensure that all of the statements in the stored procedure can be executed if another transaction is modifying rows in Table1 simultaneously.
What should you recommend?

A. Snapshot isolation
B. A database snapshot
C. Filegroups
D. Indexes

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.

Register Login

You create a stored procedure that retrieves all of the rows from a table named Table1. You need to recommend a solution

You create a stored procedure that retrieves all of the rows from a table named Table1. You need to recommend a solution

This topic has 1 reply You must be a registered member and logged in to view the replies in this topic.

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.