How to ensure that the data is unchanged during data retrieval?

Question

SQL Server

MS SLQ 2014.
I am generating a report. During formation I address to different tables.
Also, while I am generating a report, the data may change, but I need the data at the time the report is generated.
What level of isolation should be applied? And what should be done in general so that when someone else changes the data in the tables, I do not see these changes?

Answer 1

The SNAPSHOT isolation level will suit you.
https://docs.microsoft.com/en-us/sql/t-sql/stateme...