Computer-Science-Glossary | aka CSG , English

begin tran

update myTable 
set Field1 = Field1
where someKeyField = 212

-- do the same for other tables that you want to protect against change

-- at this moment all working rows will be locked, other procedure calls will be on hold

--

select custkey, dat, balance, tran, null remain from test
union
select custkey, dat, null, null, 
       sum(balance) over (partition by custkey order by dat) 
       - sum(tran) over (partition by custkey order by dat) 
  from test 
  ord

create table _g1 (v int)

set transaction isolation level snapshot
begin tran

select * from sys.dm_tran_active_snapshot_database_transactions  -- < No XSN has been assigned, yet. Zero rows are returned.

select 

SELECT Count(*)
FROM
 (
   SELECT ACCT_NBR
   FROM REPORTS.FINANCIAL_TRAN AS TRAN
   WHERE
      TRAN.TRAN_CD IN ('id1','id2','id3')  --Filters on Transaction IDs
    AND
      TRAN.TRAN_DT BETWEEN '2017-01-01' AND '2017-03-31'
   GROUP BY