They will be queued, in my experience.
Peter
On Mon, 4 Nov 2002, Josh Johnson wrote:
> I'm making a query to one table, and inserting it into another table
> (INSERT.SELECT syntax). The table that's the source of the copy is
> updated constantly, and is has a large amount of data in it. Will
> l
I'm making a query to one table, and inserting it into another table
(INSERT.SELECT syntax). The table that's the source of the copy is
updated constantly, and is has a large amount of data in it. Will
locking the table for write (or read??) access keep insert queries to
the source table from execu