Thread: Bulk insert
View Single Post
  #3 (permalink)  
Old March 3rd, 2004, 06:38 AM
deyakhatib deyakhatib is offline
Authorized User
Points: 41, Level: 1
Points: 41, Level: 1 Points: 41, Level: 1 Points: 41, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Amman, , Jordan.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to deyakhatib
Default

Hi,
there is no identity columns in the table the only constraint is an integer primary key, and I want to replace the whole row of a primary key in the table with the same primary key coming from the text file, the insert is being called from a VB.Net code when a file is generated.

Regards,


Quote:
quote:Originally posted by joefawcett
 How are you running the insert? Are you setting the KEEPIDENTITY flag?



--

Joe
Reply With Quote