Conditional SQL statement - switching between insert/update query
134950
Upserting in MS-access
61724
MySQL - UPDATE multiple rows with different values in one query
130341
SQL Insert Statement Persists Two Records When I Need Just One
89294
How do you create a yes/no boolean field in SQL server?
127800
SQL: Using NULL values vs. default values
24417
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
59954
How to compare the old and new values in a trigger for multiple fields?
68760
SQL Switch/Case in 'where' clause
110974
Switch id numbers of two rows in MySql
77455
Only inserting a row if it's not already there
124471
Comparing nullable column values using "IS NULL" versus "= NULL"
13858
Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
141930
Implementing a "Both, Either-or, but Not Null" Requirement in a Database
23716
Conditional JOIN different tables
148559
Using the correct, or preferable, not equal operator in MySQL
81524
Conditional logic in PostDeployment.sql script using SQLCMD
19860
Using a variable in a SELECT statement?