[dba-SQLServer] UPSERT

Arthur Fuller fuller.artful at gmail.com
Tue Jan 29 12:19:35 CST 2008


You may have a point here, Mark. Or at least enough reason for me to do a
quick test.

On 1/29/08, Mark A Matte <markamatte at hotmail.com> wrote:
>
>
> Arthur,
>
> I am fairly new to SQL Server...and have not had this issue...but with the
> scenario outlined below, lets switch it.  If my records were typically
> inserts with the occasional update...do you think we could reverse the order
> in the SP as long as "WHERE TicketNumber = @Parm3" was known and a PK?...or
> is the insert failing due to PK different than '0 records affected'?
>
> Thanks,
>
> Mark A. Matte
>



More information about the dba-SQLServer mailing list