Explain Codes LogoExplain Codes Logo

Sql

Insert Data Into Temp Table with Query

sql
sql-server
temp-tables
conditional-statements

Sql ON DELETE CASCADE, Which Way Does the Deletion Occur?

sql
referential-integrity
database-schema
foreign-keys

Database in use error with Entity Framework 4 Code First

sql
database-initializer
entity-framework
connection-pooling

Ora-00972 identifier is too long alias column name

sql
database-management
oracle-12.2
hibernate-configuration

Mysql SELECT AS combine two columns into one

sql
concatenation
null-values
data-types

Mysql Inner Join with WHERE clause

sql
join
where-clause
sql-pitfalls

Oracle DB: How can I write query ignoring case?

sql
case-insensitive-search
sql-functions
database-performance

Mysql Like multiple values

sql
join
performance
best-practices

Custom Order in Oracle SQL

sql
join
performance
best-practices

How to calculate age (in years) based on Date of Birth and getDate()

sql
datetime-format
date-conversion
sql-functions

Time part of a DateTime Field in SQL

sql
date-time
sql-functions
time-extraction

Mysql GROUP BY two columns

sql
subqueries
group-by
having-clause

Sql subquery with COUNT help

sql
subquery
count
performance

How to reset Postgres' primary key sequence when it falls out of sync?

sql
best-practices
sequence-reset
postgres

Add a column with a default value to an existing table in SQL Server

sql
default-values
sql-server
table-operations

Check for file exists or not in SQL Server?

sql
file-existence
sql-function
xp_fileexist

Db2 Query to retrieve all table names for a given schema

sql
db2
sql-query
database-management

Conditional WHERE clause in SQL Server

sql
conditional-where-clause
sql-performance
dynamic-sql

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

sql
subquery
join
data-integrity

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

sql
data-conversion
import-settings
data-types