Explain Codes LogoExplain Codes Logo

Sql

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

How to replace a string in a SQL Server Table Column

sql
best-practices
data-integrity
sql-server

How to get script of SQL Server data?

sql
script-generation
data-consistency
sql-server
explain.codes / Sql