Explain Codes LogoExplain Codes Logo

Sql

How to Select a Substring in Oracle SQL up to a Specific Character?

sql
prompt-engineering
join
best-practices

Should every SQL Server foreign key have a matching index?

sql
indexing
performance-optimization
database-management

Sql script to find invalid email addresses

sql
email-validation
sql-scripts
data-cleansing

Return rows in random order

sql
randomization
database-performance
data-analysis

Sql Server - where is "sys.functions"?

sql
best-practices
performance
functions

Mysql Select Records for Duplicates Using Multiple Columns

sql
prompt-engineering
join
performance

Mysql order by "best match"

sql
prompt-engineering
best-practices
performance

What is the difference between a primary key and a unique constraint?

sql
data-integrity
database-design
performance-tuning

Why does Sql Server keep executing after raiserror when xact_abort is on?

sql
best-practices
error-handling
transaction-management

See whether an item appears more than once in a database column

sql
duplicates
sql-queries
database-management

Can I protect against SQL injection by escaping single-quote and surrounding user input with single-quotes?

sql
input-validation
sql-injection
stored-procedures

Create table with sequence.nextval in Oracle

sql
sequence-engineering
identity-columns
oracle-12c

Show MySQL host via SQL Command

sql
mysql
sql-commands
database-troubleshooting

How to update and order by using ms sql

sql
subqueries
update-rows
sql-tricks

Get the last day of the month in SQL

sql
performance
best-practices
functions

How much disk-space is needed to store a NULL value using postgresql DB?

sql
database-administration
performance-optimization
data-management

Define variable to use with IN operator (T-SQL)

sql
table-variables
in-operator
sql-server

T-sql split string based on delimiter

sql
string-splitting
sql-server
delimiter

Postgresql Foreign Key syntax

sql
foreign-key
database-design
data-integrity

How to delete from multiple tables in MySQL?

sql
join
foreign-key
subqueries