Tools › CSV → MERGE

Excel / CSV to SQL Server MERGE (upsert)

INSERT breaks when the email is already there. MERGE is update-or-insert. First row is headers. One key column.

MERGE has held a few locking surprises over the years. For a huge load, a staging table + UPDATE/INSERT pair is kinder. Related: CSV INSERT.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.

Clock in free