emi_sastra
asked on
READING UNCOMMITTED SAVE TO DATATABLE
Hi All,
In the middle of inserting data, I want to read that uncommitted table to get another data and store it to datatable.
Private functio Read_Uncommitted_Table(Trs
cmdSQLCommand as sqlcommand) as datatable
dim dtTable as datatable
return dtTable
End Sub
How could I do it ?
Thank you.
In the middle of inserting data, I want to read that uncommitted table to get another data and store it to datatable.
Private functio Read_Uncommitted_Table(Trs
cmdSQLCommand as sqlcommand) as datatable
dim dtTable as datatable
return dtTable
End Sub
How could I do it ?
Thank you.
ASKER
Hi s_chilkury,
Could set it using vb code at the Read_Uncommitted_Table function ?
Thankyou.
Could set it using vb code at the Read_Uncommitted_Table function ?
Thankyou.
Are you using stored procedure or text command? If text command, then try this
sqlcmd.CommandText = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ; Select ..."
sqlcmd.CommandText = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ; Select ..."
ASKER
Hi CodeCruiser,
I use text command.
Which one is better, Isolation Level or Read With (NoLock) ?
And Why ?
Thank you.
I use text command.
Which one is better, Isolation Level or Read With (NoLock) ?
And Why ?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok.
Thank you very much for your help.
Thank you very much for your help.
The SP which fetches the records should have the following statement at the start of the batch statements:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;