Database Reference
In-Depth Information
The following statement will update one of the rows in the
t1
table. The code uses
an explicit begin transaction and a corresponding commit. In previous versions
of SQL Server, at this point you could be certain that the transaction had been
hardened to the transaction log. The following code will insert a row into
t1
using
Delayed Durability:
begin transaction
update t1
set name = 'Seth Ellis'
WHERE ID =1
commit transaction with (delayed_durability = ON)
Search WWH ::
Custom Search