Insert/Update

Hi,
Is it possible to Read data From a Table while Insertion/Update is happening on the table??
In case if this is not possible,Is there anyway to do that??

Thanks,
KarthikIf you need accurate, dependable data, then there isn't a way to get that without waiting for the INSERT/UPDATE/DELETE transactions to finish.

If all you need to do is browse the data, and it doesn't matter if that data is not 100% complete or accurate, then you can use either the NOLOCK index hint, or the SET TRANSACTION_ISOLATION_LEVEL command.

-PatP|||Hi ,
Thanks for ur suggestion.

More inputs on this is welcome.

Thanks,
Karthik