Explain Codes LogoExplain Codes Logo

Sql

Why does this SQLite query select all dates, even those outside of the criteria?

sql
prompt-engineering
best-practices
date-functions

Sql Server FOR EACH Loop

sql
set-based-operations
recursive-cte
execution-plans

Full OUTER JOIN with SQLite

sql
full-outer-join
sqlite
sql-queries

How to Handle a Single Quote in Oracle SQL

sql
sql-injection
dynamic-sql
concatenation

Bulk/batch update/upsert in PostgreSQL

sql
bulk-inserts
performance-optimization
postgresql

What are the differences between T-SQL, SQL Server, and SQL

sql
sql-server
t-sql
database-management

How can I get a plain text postgres database dump on Heroku?

sql
database-dump
heroku
postgres

Extracting Hours from a DateTime (SQL Server 2005)

sql
datepart-function
datetime-components
performance-tips

Disable all table constraints in Oracle

sql
constraint-handling
plsql
database-performance

Difference between primary key and unique key

sql
database-design
data-integrity
key-concepts

How can I backup a remote SQL Server database to a local drive?

sql
backup
sql-server
database-management

Can you have if-then-else logic in SQL?

sql
prompt-engineering
best-practices
performance

Sql Delete Records within a specific Range

sql
data-recovery
sql-queries
database-management

Getting return value from stored procedure in C#

sql
stored-procedures
best-practices
error-handling

Is it faster to access data from files or a database server?

sql
benchmarking
database-performance
data-access-strategies

Imply bit with constant 1 or 0 in SQL Server

sql
best-practices
data-types
typecasting

Mysql: How to Add One Day to Datetime Field in Query

sql
datetime
interval
date-add

Get week day name from a given month, day, and year individually in SQL Server

sql
date-parsing
sql-server
date-functions

Selecting unique values from a column

sql
distinct
performance
best-practices

What's the best way to select the minimum value from several columns?

sql
best-practices
performance
join
explain.codes / Sql