Explain Codes LogoExplain Codes Logo

Sql

How to COALESCE for empty strings and NULL values?

sql
sql-functions
performance-optimization
best-practices

Sql Joins Vs SQL Subqueries (Performance)?

sql
join
subquery
performance

Sql Server procedure declare a list

sql
table-valued-parameters
dynamic-sql
sql-server

Combining ORDER BY AND UNION in SQL Server

sql
union
order-by
sub-queries

How do I put an 'if clause' in an SQL string?

sql
conditional-statements
subqueries
join

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