Explain Codes LogoExplain Codes Logo

Sql

Find a string by searching all tables in SQL Server

sql
sql-injection
database-optimization
sql-server

Sql, Auxiliary table of numbers

sql
performance
best-practices
sql-server

Mysql: Select DISTINCT / UNIQUE, but return all columns?

sql
distinct
group-by
sql-performance

Are PostgreSQL column names case-sensitive?

sql
database-migration
sql-standards
best-practices

Mysql: GROUP_CONCAT with LEFT JOIN

sql
join
groupby
performance-tuning

Having issues with a MySQL Join that needs to meet multiple conditions

sql
join
best-practices
performance

How to do select from where x is equal to multiple values?

sql
subqueries
join
performance

Postgresql query between date ranges

sql
date-range
postgresql
database-optimization

Convert Rows to columns using 'Pivot' in SQL Server

sql
pivot-engineering
sql-string
dynamic-sql

Sql Server - transactions roll back on error?

sql
transactional-anomalies
error-handling
try-catch-block

Library of Useful (Difficult) SQL scripts

sql
data-integrity
performance-optimization
sql-scripts

Mysql: Typecasting NULL to 0

sql
database-optimizations
data-analytics
null-handling

Update MySQL with if condition

sql
conditional-updates
sql-queries
database-performance

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