Re: Can this be done??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Morten Overgaard (mov_at_oticon.dk)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 16:51:17 +0200

Let me rephrase.

Actually what I meant was

Is it possible for a transaction to only select the rows inserted by the
transaction itself ie. all other rows in the table created by other
transaction are not returned in a SELECT statement.

Thanks in advance

Regards Morten

"Morten Overgaard" <mov@oticon.dk> wrote in message
news:%233LALWGLEHA.988@TK2MSFTNGP11.phx.gbl...
> Hi Sirs
>
> Is it possible to create a transaction which inserts data into a table in
> such a way that all the inserted rows are NOT visible to other processes
> accessing the same table until the transaction commits the data??
>
> Thanks in advance
>
> Regards Morten
>
>

Quantcast