Explain Codes LogoExplain Codes Logo

Sql

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

Get generated id after insert

sql
database-resources
performance-optimization
best-practices

Difference between one-to-many and many-to-one relationship

sql
database-design
data-integrity
normalization

Sql SELECT from multiple tables

sql
join
union
query-optimization

Sql "between" not inclusive

sql
date-comparison
datetime
inclusive-query

How to identify all stored procedures referring to a particular table

sql
sql-server
stored-procedures
database-management

Rank function in MySQL

sql
rank-function
mysql-optimization
sql-queries

When is a good situation to use a full outer join?

sql
join
performance
best-practices

How do I find the data directory for a SQL Server instance?

sql
sql-server
database-management
data-directory

Split string and take last element

sql
functions
best-practices
conditional-checks
explain.codes / Sql