Explain Codes LogoExplain Codes Logo

Sql

Error on renaming database in SQL Server 2008 R2

sql
database-renaming
sql-server-2008-r2
best-practices

How to get the trigger(s) associated with a view or a table in PostgreSQL

sql
database-internals
trigger-management
postgresql

How to do IF NOT EXISTS in SQLite

sql
best-practices
data-integrity
sqlite-capabilities

How do I determine if a database role exists in SQL Server?

sql
database-roles
sql-server
role-existence

Postgresql turn null into zero

sql
data-quality
default-values
null-handling

How to extract year and month from date in PostgreSQL without using to_char() function?

sql
date_trunc
extract
date_part

Postgresql - add boolean column to table set default

sql
database-design
data-integrity
sql-queries

Case insensitive searching in Oracle

sql
function-based-indexes
case-insensitive-searching
oracle-performance

Update or Insert (multiple rows and columns) from subquery in PostgreSQL

sql
subqueries
upsert
performance

How do I rename a column in a database table using SQL?

sql
database-renaming
sql-server
best-practices

Difference between IN and ANY operators in SQL

sql
subquery
performance
best-practices

How to return result of a SELECT inside a function in PostgreSQL?

sql
sql-functions
postgresql
best-practices

Error: there is no unique constraint matching given keys for referenced table "bar"

sql
unique-constraints
database-integrity
postgresql

Oracle SELECT TOP 10 records

sql
performance
best-practices
execution-plan

Oracle "Partition By" Keyword

sql
prompt-engineering
best-practices
window-functions

Sql: BETWEEN vs <= and >=

sql
best-practices
performance
sql-queries

Group BY and COUNT in PostgreSQL

sql
prompt-engineering
performance
best-practices

What is a 'multi-part identifier' and why can't it be bound?

sql
sql-best-practices
sql-troubleshooting
sql-queries

Order BY the IN value list

sql
advanced-sorting
postgresql
sql-functions

Order BY "ENUM field" in MYSQL

sql
database-management
mysql-optimization
enum-data-type
explain.codes / Sql