SQL Server insert if not exists best practice [closed]

by

Semantically you are asking “insert Competitors where doesn’t already exist”:

INSERT Competitors (cName)
SELECT DISTINCT Name
FROM CompResults cr
WHERE
   NOT EXISTS (SELECT * FROM Competitors c
              WHERE cr.Name = c.cName)

More Related Contents:

  1. What is the best way to create and populate a numbers table?
  2. How do I generate a random number for each row in a T-SQL select?
  3. Auto increment primary key in SQL Server Management Studio 2012
  4. What is the use of the square brackets [] in sql statements?
  5. Construct date from year and week number in MSSQL
  6. Reset AutoIncrement in SQL Server after Delete
  7. XML Server XML performance optimization
  8. SQL Server: Attach incorrect version 661
  9. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  10. How to do version control for SQL Server database?
  11. Get dates from a week number in T-SQL
  12. What are named pipes?
  13. How to check if a database exists in SQL Server?
  14. BULK INSERT with identity (auto-increment) column
  15. How to update primary key
  16. determining the character set of a table / database?
  17. How to split string and insert values into table in SQL Server
  18. Case sensitive variables in SQL Server
  19. How to query for Xml values and attributes from table in SQL Server?
  20. SQL Server 2008 Row Insert and Update timestamps
  21. Full text search does not work if stop word is included even though stop word list is empty
  22. Should I index a bit field in SQL Server?
  23. Setting up maven dependency for SQL Server
  24. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  25. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  26. Escaping single quote in SQL Server
  27. SQL Server equivalent to Oracle’s CREATE OR REPLACE VIEW
  28. In SQL Server, how can I find everywhere a column is referenced?
  29. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  30. Convert float into varchar in SQL Server without scientific notation

Leave a Comment