Explain Codes LogoExplain Codes Logo

Sql

Postgresql IF statement

sql
conditional-logic
database-performance
error-handling

Exists vs JOIN and use of EXISTS clause

sql
exists-clause
join-operations
sql-performance

How to format bigint field into a date in PostgreSQL?

sql
timestamp
type-casting
date-formatting

How to write UPDATE SQL with Table alias in SQL Server 2008?

sql
best-practices
join
cte

Generate a random number in the range 1 - 10

sql
random-numbers
sql-functions
database-queries

Tsql - Cast string to integer or return default value

sql
try-catch
sql-server
data-type

Generate insert script for selected records?

sql
prompt-engineering
data-types
sql-scripts

Composite Primary Key On Table Variable In Stored Procedure

sql
composite-keys
data-integrity
sql-server

Inserting data into a temporary table

sql
best-practices
data-transfer
database-management

To ignore duplicate keys during 'copy from' in PostgreSQL

sql
data-integrity
database-design
postgresql

Sql: sum 3 columns when one column has a null value?

sql
null-handling
sql-queries
database-optimization

Sql: Alias Column Name for Use in CASE Statement

sql
subqueries
ctes
sql-queries

Finding the next available id in MySQL

sql
auto-increment
id-allocation
mysql-optimization

How to get last inserted id?

sql
sql-exceptions
resource-management
output-parameter

Replace null with 0 in MySQL

sql
null-replacement
mysql-functions
best-practices

Sql Error: ORA-01861: literal does not match format string 01861

sql
date-format
oracle-error
sql-best-practices

Sql Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=

sql
subquery
aggregate-functions
join

What's the best SQL datatype for storing JSON string?

sql
json-storage
sql-server
database-performance

Update multiple rows in Entity Framework from a list of ids

sql
bulk-operations
entity-framework
database-performance

Are left outer joins and left joins the same?

sql
join
best-practices
performance
explain.codes / Sql