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

  Discussion forum


Leave an answer