Search for existing suggestions

Ignore Duplicate Inserts

On the context simply allow a setting to ignore duplicate insertions. It should just add a not exist sub select query to ensure that a duplicate is not inserted on say a primary key or unique key...

This just removes a lot of admin on the insert side of things. If the data is already there why complain about about it unless you need to handle it.

This will be exceptionally useful on a many to many insert. If this is in place then I dont need to first check both sides of the insert to ensure that the data does not exist before inserting! Just insert and return a 0 rows affected var if it already exists

2 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Ivan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base