DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 17

Thread: SQL query how to find !!

Threaded View

  1. #11
    Join Date
    Oct 2000
    Posts
    467
    Originally posted by bang_dba
    If i have 100 inserts to be done, and there is a error at 50 th record, then the control jumps to Exception. Right ????

    Is there any way that i just skip this bad record and continue with the rest 50 records ????
    Just give commit after the whole operation...it's faster and better. As for the bad record, check the spool/log file and remove them from the source.
    Last edited by vinit; 01-20-2004 at 07:50 AM.
    Vinit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width