Up Prev Next
From: "WORENKLEIN, David, GCM" <David dot Worenklein at gcm dot com>
Subject: RE: bcp and select, not the same time?
Date: Jul 30 1999 1:41PM
You can bcp into a temp table. Then, when you're done, you can
insert into real_table
select * from temp_table
From: AGHZHONG@aol.com [mailto:AGHZHONG@aol.com]
Sent: Friday, July 30, 1999 8:16 AM
To: SybPerl Discussion List
Subject: Re: bcp and select, not the same time?
Thanks for writing. You are right, my program is locking itself up. I was
and bcp in from/to the same table. I have never thought that bcp_sendrow
lock the data page. I thought bcp_batch is the time when data page get
The sybook has the following words on bcp_sendrow:
"rows are permanently saved in SQL Server only when the user calls
bcp_batch or bcp_done". I should have read between lines.
I now have to abandon the bcp idea for what I am doing. This is bad!
Thanks again for help