Explain Codes LogoExplain Codes Logo

Sql

How can I import a SQL file into a Rails database?

sql
database-connection
rails-migration
sql-import

Is there any difference between "!=" and "<>" in Oracle Sql?

sql
best-practices
performance
sql-standards

Add a column to a table with a default value equal to the value of an existing column

sql
database-expert
performance-optimization
data-integrity

Bulk insert, update if on conflict (bulk upsert) on Postgres

sql
bulk-insert
upsert
postgresql

Pl/pgsql checking if a row exists

sql
performance
best-practices
database-optimization

How do I do multiple CASE WHEN conditions using SQL Server 2008?

sql
best-practices
join
case-statement

How to do pagination in SQL Server 2008

sql
pagination
sql-server
performance

How do composite indexes work?

sql
indexing
database-optimization
query-performance

T-sql: Selecting Column Based on MAX(Other Column)

sql
window-functions
join-optimization
sql-performance

How to join on multiple criteria, returning all combinations of both criteria?

sql
join
sqlfiddle
best-practices

How to include BIT type column in SELECT part without including it on the GROUP BY in T-SQL?

sql
aggregate-functions
sql-queries
t-sql

Foreign key constraints: When to use ON UPDATE and ON DELETE

sql
database-design
foreign-keys
data-consistency

Postgresql: SQL script to get a list of all tables that have a particular column as foreign key

sql
foreign-keys
database-queries
sql-scripts

Limit on the WHERE col IN (...) Condition

sql
sub-selects
query-parameterization
aggregations

Mysql datetime comparison

sql
datetime-comparison
sql-best-practices
data-types

Does MS SQL Server's "between" include the range boundaries?

sql
datetime
dateadd
best-practices

Sql Server User Mapping Error 15023

sql
sql-server
error-handling
database-administration

Update statement using with clause

sql
prompt-engineering
best-practices
performance

Sql unique varchar case sensitivity question

sql
case-sensitivity
collation
database-design

Most efficient way in SQL Server to get date from date+time?

sql
performance
best-practices
sargability
explain.codes / Sql