Explain Codes LogoExplain Codes Logo

Sql

Create parameterized VIEW in SQL Server 2008

sql
performance
best-practices
execution-plans

How to copy a row from one SQL Server table to another

sql
data-transfer
sql-performance
sql-best-practices

Is it possible to specify condition in Count()?

sql
conditional-counting
advanced-sql
case-statement

How do I do a simple 'Find and Replace' in MsSQL?

sql
best-practices
sql-queries
error-handling

Formatting Numbers by padding with leading zeros in SQL Server

sql
data-type-conversion
performance-optimization
best-practices

Check if entry in table A exists in table B

sql
not-exists
left-join
not-in

Search and replace part of string in database

sql
database-backup
string-replacement
sql-queries

How to create Temp table with SELECT * INTO tempTable FROM CTE Query

sql
temp-tables
cte
sql-performance

Deleting duplicate rows from sqlite database

sql
database-normalization
performance-optimization
data-modeling

Convert Month Number to Month Name Function in SQL

sql
date-manipulation
sql-functions
dynamic-sql

Delete statement in SQL is very slow

sql
performance
optimization
best-practices

Postgresql - change the size of a varchar column to lower length

sql
database-alterations
postgresql-tips
data-integrity

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