Explain Codes LogoExplain Codes Logo

Sql

Postgresql: Remove attribute from JSON column

sql
json-manipulation
postgresql-features
database-performance

Replace Into Query Syntax

sql
best-practices
performance
data-integrity

Tinyint vs Bit?

sql
database-design
data-types
sql-server

Is there a way to list open transactions on SQL Server 2000 database?

sql
dbcc
transactions
sql-server-2000

Sql Query To Obtain Values That Occur More Than Once

sql
sql-query
group-by
count

Convert integer to hex and hex to integer

sql
convert-function
hex-string
sql-server

Solutions for INSERT OR UPDATE on SQL Server

sql
transactional-updates
concurrency-control
upsert-pattern

Paging with Oracle

sql
pagination
oracle
sql-optimization

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
explain.codes / Sql