Explain Codes LogoExplain Codes Logo

Sql

Sql: IF clause within WHERE clause

sql
conditional-statements
sql-performance
best-practices

How do I use an INSERT statement's OUTPUT clause to get the identity value?

sql
output-clause
identity-value
insert-statement

Ora-12560: TNS:protocol adapter error

sql
ora-12560
tns-protocol-error
oracle-services

Creating new database from a backup of another Database on the same server?

sql
backup
restore
database

Mysql procedure vs function, which would I use when?

sql
transaction-management
database-security
performance-optimization

Difference of two date time in SQL Server

sql
datetime
date-diff
sql-server

List rows after specific date

sql
date-comparisons
sql-performance
best-practices

In Clause with NULL or IS NULL

sql
null-handling
subqueries
best-practices

What is the difference between IFNULL and COALESCE in MySQL?

sql
best-practices
performance
join

How to count instances of a character in a SQL column

sql
prompt-engineering
best-practices
performance

How do I use alias in where clause?

sql
subqueries
performance-optimization
sql-server

Not equal <> != operator on NULL

sql
null-handling
sql-queries
best-practices

How do I compare two columns for equality in SQL Server?

sql
join
best-practices
performance

Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?

sql
database-creation
postgresql
conditional-creation

Insert Update stored proc on SQL Server

sql
upsert
performance-tuning
best-practices

Get the week start date and week end date from week number

sql
date-arithmetic
date-part
dateadd

Trying to modify a constraint in PostgreSQL

sql
data-integrity
constraint-modification
postgresql

Import postgres database without roles

sql
database-import
postgres
roles

Foreign key reference to table in another schema

sql
foreign-key
database-performance
data-integrity

Not DEFERRABLE versus DEFERRABLE INITIALLY IMMEDIATE

sql
constraint-violation
database-design
performance-optimization
explain.codes / Sql