OPTION (IGNORE ERRORS)

Normally a SQL query returns an error as soon a database call throws an exception. This query hint allows retrieving data to continue even if previous rows are in error. The result set will just omit rows in error, but return all other rows.

This query hint is not supported by all tables. Tables that support OPTION (IGNORE ERRORS) are listed in Table and Table-Valued Function structures.