Conditional Inserts in SQL Server

Categories: ColdFusion, SQL

A conditional Insert is often used when inserting a record, and you want to make sure that the record doesn’t already exist. There are several ways to accomplish this task. First, you can rely on Primary Key or Unique constraints to ensure data integrity, which are best-practice and should be implemented. You can also add some logic to your SQL statements to prevent duplicate records.

Read More