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