Chad Baldwin wants to check if rows exist before inserting:
I haven’t posted in a while, so I thought I would throw a quick one together to hopefully restart the habit of writing and posting on a regular basis.
One of my first blog posts covered how to only update rows that changed. In that post, I described a popular method that uses
EXCEPTto find rows that had changed while also implicitly handling
Click through for two types of technique, one for non-nullable data and one which can include NULL.