how to prevent read uncommited  data(SQL Server)
Question

Hi,

I am using SQL Server (Isolation level: READ UNCOMMITTED), Outsystems11.

I create a timer to update a table. 

How can I  get data from table without(exclude) uncommited  data?

Thank you very much.

mvp_badge
MVP

Hi Shake Mountain,

You could try something like this, which in theory should work but is strongly disencouraged, as it can cause unexpected locks!

SET TRANSACTION ISOLATION LEVEL READ COMMITTED
/* do something */

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Regards,

Daniel

Hi Daniel,

I  have tried in advanced sql, but  return error like this 

(SET TRANSACTION ISOLATION LEVEL READ COMMITTED  Select * from {}): Incorrect syntax near the keyword 'SET'.


 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.