Explain Codes LogoExplain Codes Logo

Sql

How to find which views are using a certain table in SQL Server (2008)?

sql
database-administration
sql-server
dependency-management

Delete duplicate records in SQL Server?

sql
data-integrity
database-management
sql-queries

Why use "where 1=2" on a SQL CREATE TABLE syntax?

sql
database-schema
table-structure
dataless-table

Using "GO" within a transaction

sql
transactional-execution
batch-separators
variable-scope

How do I loop through a set of records in SQL Server?

sql
set-based-operations
performance-optimization
database-management

Subquery using Exists 1 or Exists *

sql
exists-clause
sql-server
performance-optimization

Mysql Select last 7 days

sql
date-time
interval
database-functions

Sql, Postgres OIDs, What are they and why are they useful?

sql
oid-management
postgresql-optimization
database-migration

How to delete from select in MySQL?

sql
performance
best-practices
join

Why use SQL database?

sql
database-optimization
sql-performance
orm-issues

Sql query to select data from 1 hour ago?

sql
timezones
date-functions
sql-queries

Sort NULL values to the end of a table

sql
null-handling
sql-sorting
database-optimization

How do I use properly CASE..WHEN in MySQL

sql
best-practices
sql-queries
conditional-statements

A beginner's guide to SQL database design

sql
database-design
data-integrity
sql-queries

Using SQL count in a case statement

sql
conditional-aggregates
sql-functions
best-practices

How to use a calculated column to calculate another column in the same view

sql
prompt-engineering
best-practices
performance

Select multiple columns from a table, but group by one

sql
join
groupby
subqueries

How to use table variable in a dynamic sql statement?

sql
temp-tables
dynamic-sql
performance

Explanation of self-joins

sql
self-join
data-normalization
performance-optimization

How to restore PostgreSQL dump file into Postgres databases?

sql
database-management
backup-and-restore
postgresql
explain.codes / Sql