Explain Codes LogoExplain Codes Logo

Sql

Is there a way to persist a variable across a go?

sql
sqlcmd
stored-procedures
dynamic-sql

How to check type of value in postgres

sql
conditional-statements
postgresql
type-checking

Sql - How do I get only the numbers after the decimal?

sql
decimal-extraction
sql-functions
data-manipulation

How to flip bit fields in T-SQL?

sql
bit-manipulation
sql-queries
performance-tips

What is the difference between GROUP BY and ORDER BY in SQL?

sql
group-by
order-by
sql-queries

Using "like" wildcard in prepared statement

sql
prompt-engineering
best-practices
performance

Handling List-types with Esqueleto

sql
database-operations
list-types
sql-queries

Mysql, Concatenate two columns

sql
join
concatenation
data-integrity

Difference between Top and Limit Keyword in SQL

sql
database-compatibility
pagination
query-performance

How do I view the Explain Plan in Oracle SQL developer?

sql
explain-plan
sql-developer
performance-tuning

Alter data type of a column to serial

sql
prompt-engineering
best-practices
sequence-management

Declare local variables in PostgreSQL?

sql
best-practices
sql-variables
plpgsql

Convert Date format into DD/MMM/YYYY format in SQL Server

sql
date-formatting
sql-server
date-conversion

Copy table structure to a new table in SQLite3

sql
database-management
sqlite
schema-management

Sql-server: Error - Exclusive access could not be obtained because the database is in use

sql
exclusive-access
database-restoration
backup-file-path

Mixing explicit and implicit joins fails with "There is an entry for table ... but it cannot be referenced from this part of the query"

sql
best-practices
join
sql-engine

What is the syntax meaning of RAISERROR()

sql
error-handling
sql-server
database-management

Select group of rows that match all items in a list

sql
subquery
join
performance

How to detect if a string contains at least a number?

sql
pattern-matching
sql-server
postgresql

Optimistic locking in MySQL

sql
transaction-management
optimistic-locking
database-isolation-levels