By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,176 Members | 984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,176 IT Pros & Developers. It's quick & easy.

COPY COMMAND

P: n/a
Hi All,
Is it possible to insert n rows with 1 or 2 invalid rows
using copy command. I used it, it rollbacks everything even if 1 row
gets an error. Is their any other way to do it.

TIA

--
regards,
Deepa K.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tuesday 07 October 2003 07:29, Deepa K wrote:
Hi All,
Is it possible to insert n rows with 1 or 2 invalid rows
using copy command. I used it, it rollbacks everything even if 1 row
gets an error. Is their any other way to do it.


You need to remove the bad rows. This is IMHO a "Good Thing" (TM) although it
can be irritating.

You should get a line number to indicate where the problem rows are.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.