Explain Codes LogoExplain Codes Logo

Sql

Where statement after a UNION in SQL?

sql
sql-performance
best-practices
query-optimization

Using a Single Row configuration table in SQL Server database. Bad idea?

sql
best-practices
schema-design
database-optimization

What is Ad Hoc Query?

sql
ad-hoc-queries
sql-performance
database-optimization

How do you create a temporary table in an Oracle database?

sql
database-design
performance-optimization
sql-queries

How to write a WHERE Clause to find all records in a specific month?

sql
join
best-practices
performance

Mysql Sum() multiple columns

sql
join
performance
best-practices

Export database schema into SQL file

sql
database-schema
sql-server
scripting

How to change the column position of a MySQL table without losing column data?

sql
database-structure
backup-plan
sql-alter-table

Cannot get simple PostgreSQL insert to work

sql
database-engineering
sql-best-practices
postgresql-tips

How can I get all sequences in an Oracle database?

sql
database-management
sql-queries
performance-optimization

Ms SQL Exception: Incorrect syntax near '@P0'

sql
sql-server
hibernate-configuration
sql-syntax

Left Outer Join using + sign in Oracle 11g

sql
join
sql-syntax
best-practices

Getting list of tables, and fields in each, in a database

sql
metadata
database-queries
sql-server

Can I Create a One-Time-Use Function in a Script or Stored Procedure?

sql
dynamic-sql
stored-procedures
temp-tables

Inserting rows into a table with one IDENTITY column only

sql
identity-columns
database-design
transaction-safety

Sql query with NOT LIKE IN

sql
prompt-engineering
best-practices
join

How do I grant myself admin access to a local SQL Server instance?

sql
sqlcmd
single-user-mode
sysadmin-role

What is the best way to implement soft deletion?

sql
soft-deletion
database-views
partitioning

Mysql - SELECT all columns WHERE one column is DISTINCT

sql
distinct
group-by
subqueries

Equivalent of explode() to work with strings in MySQL

sql
prompt-engineering
functions
best-practices