[dba-SQLServer] SQL Server - Append records without fail

OK, good to know!

Thanks,

John W. Colby
www.ColbyConsulting.com

On 5/2/2011 5:18 PM, Asger Blond wrote:
> John,
> If the unique index is created with the option IGNORE_DUP_KEY then the behaviour will be the same as in Access.
> Asger
>
> -----Oprindelig meddelelse-----
> Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af jwcolby
> Sendt: 2. maj 2011 22:27
> Til: Access Developers discussion and problem solving; Sqlserver-Dba
> Emne: [dba-SQLServer] SQL Server - Append records without fail
>
> In access you can append records into a table and if a given record fails, the rest go in.  I use
> that as a quick and dirty filter sometimes when (for example) appending records from one place to
> another.
>
> AFAICT SQL Server will not append any of the records if any single record fails to append, which has
> always seemed strange to me.  It's almost like an unrequested rollback.
>
> Is there any way to make SQL Server accept the appends that will go in and only reject the ones that
> will not for some reason?
>