Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2006-12-31 : 09:42:27
|
| I am using SQL Server 2005 Management Studio Express.I am trying to insert records in bulk into "students" table.Students:uniqueid varchar(9) (primary Key)lname varchar(35)fname varchar(35)My problem is when one record from the bulk record already exists in Students table all the bulk insert fails. I dont want that. I want rest of the records to be inserted smoothly with no error.How can I do it....Is there any disadvantage if i do this???? |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2006-12-31 : 19:15:12
|
| I guess I'll just assume that you're using BULK INSERT and nothing else... set the MAX ERRORS option to what you desire. See Books Online under BULK INSERT for additional details.If you are not using BULK INSERT, then please post the code that's doing the BULK INSERT.--Jeff Moden |
 |
|
|
|
|
|
bulk insertion sql server 2005