Explain Codes LogoExplain Codes Logo

Sql

Altering column size in SQL Server

sql
best-practices
data-integrity
sql-syntax

How to do the Recursive SELECT query in MySQL?

sql
recursive-procedures
best-practices
stored-procedures

How to update selected rows with values from a CSV file in Postgres?

sql
best-practices
data-integrity
performance

Get list of all tables in Oracle?

sql
database-views
oracle-queries
metadata

Set database from SINGLE USER mode to MULTI USER

sql
database-management
sql-server
multi-user-mode

How to select a column name with a space in MySQL

sql
best-practices
sql-syntax
database-management

Detect if value is number in MySQL

sql
regexp
mysql
numeric-patterns

How to retrieve JSON data from MySQL?

sql
json-handling
mysql-performance
database-normalization

Insert statement conflicted with the FOREIGN KEY constraint - SQL Server

sql
foreign-key
database-design
error-handling

Sql try/catch rollback/commit - preventing erroneous commit after rollback

sql
error-handling
transaction-management
sql-server

How to write "not in ()" sql query using join

sql
join
best-practices
performance

How to install localdb separately?

sql
localdb
sql-server-express
database-management

How to check which locks are held on a table

sql
database-management
lock-management
sql-queries

How to use Oracle ORDER BY and ROWNUM correctly?

sql
prompt-engineering
best-practices
performance

How do I query for all dates greater than a certain date in SQL Server?

sql
date-formatting
sql-functions
date-comparisons

Double colon `::` notation in SQL

sql
type-casting
date-handling
sql-dialects

Insert results of a stored procedure into a temporary table

sql
temp-tables
stored-procedures
performance-optimization

Sql update query using joins

sql
update-query
sql-joins
sql-aliases

How to increase SQL*Plus column output length?

sql
best-practices
data-integrity
performance

Linq to SQL - Left Outer Join with multiple join conditions

sql
linq
join
performance
explain.codes / Sql