Re: [GENERAL] Inserting into a master table with partitions does not return rows affected.

On Tue, May 10, 2016 at 3:53 AM rverghese wrote: > I am moving towards a partitioned schema. I use a function to insert into > the > table. If the INSERT fails because of duplicates I do an UPDATE. This works > fine currently on the non-partitioned table because I can use GET > DIAGNOSTICS to get

[GENERAL] Inserting into a master table with partitions does not return rows affected.

I am moving towards a partitioned schema. I use a function to insert into the table. If the INSERT fails because of duplicates I do an UPDATE. This works fine currently on the non-partitioned table because I can use GET DIAGNOSTICS to get the row count on the INSERT. But when I use the Master tabl