Explain Codes LogoExplain Codes Logo

Sql

Passing multiple values for a single parameter in Reporting Services

sql
string-split
custom-functions
sql-injection

What are the use cases for selecting CHAR over VARCHAR in SQL?

sql
data-types
performance
storage-optimization

How do I rename an Index in MySQL

sql
indexing
database-maintenance
foreign-keys

Group BY having MAX date

sql
query-optimization
group-by
joins

What is the purpose of constraint naming

sql
constraint-naming
best-practices
database-integration

Ordering by the order of values in a SQL IN() clause

sql
sorting
best-practices
joins

How can I find which tables reference a given table in Oracle SQL Developer?

sql
case-sensitivity
foreign-keys
querying

Select where count of one field is greater than one

sql
group-by
having
subquery

How to insert table values from one database to another database?

sql
data-transfer
permissions
network-issues

How can I do an UPDATE statement with JOIN in SQL Server?

sql
update
join
performance

Oracle Differences between NVL and Coalesce

sql
nvl
coalesce
performance

How to strip HTML tags from a string in SQL Server?

sql
html-stripping
user-defined-functions
xml-method

Find all tables containing column with specified name - MS SQL Server

sql
information-schema
metadata
query-optimization

Select count(*) from multiple tables

sql
count
joins
performance

Mysql Foreign key constraint is incorrectly formed error

sql
foreign-key
data-integrity
indexing

Mysql - Get row number on select

sql
row-number
subqueries
pagination

How to get input file name as column in AWS Athena external tables

sql
aws
data-lake
query-optimization

Sql Server: IF EXISTS ; ELSE

sql
performance
set-based
case

Simple Random Samples from a MySQL Sql database

sql
random-sampling
performance
query-optimization

Cross JOIN vs INNER JOIN in SQL

sql
inner-join
cross-join
performance
explain.codes / Sql