Explain Codes LogoExplain Codes Logo

Sql

Can't drop table: A foreign key constraint fails

sql
foreign-key-constraints
database-management
data-integrity

Two single-column indexes vs one two-column index in MySQL?

sql
indexing
performance
database-optimization

How to declare a variable in MySQL?

sql
database-management
sql-variables
mysql-queries

Entering keys manually with Entity Framework

sql
entity-framework
database-integrity
transactions

What is "Connect Timeout" in SQL Server connection string?

sql
connection-string
timeout-settings
sql-server-configuration

Remove Primary Key in MySQL

sql
database-schema
sql-queries
data-backup

How to select date without time in SQL

sql
date-truncation
sql-performance
best-practices

Count the number of occurrences of a string in a VARCHAR field?

sql
sql-functions
performance-optimization
database-management

How can I use SUM for bit columns?

sql
bit-manipulation
aggregate-functions
t-sql

How can I search (case-insensitive) in a column using LIKE wildcard?

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

Entity Framework. Delete all rows in table

sql
entity-framework
database-management
data-deletion

Sql UPDATE all values in a field with appended string CONCAT not working

sql
null-values
concat-function
mysql-quirks

Sql - Select First 10 Rows Only?

sql
limit
offset
fetch-first

Mysql "Group By" and "Order By"

sql
join
subqueries
indexing

How to change a PG column to NULLABLE TRUE?

sql
database-design
performance-implications
postgresql

Use multiple conflict_target in ON CONFLICT clause

sql
prompt-engineering
best-practices
conflict-resolution

How to Store a List in a DB Column

sql
database-normalization
data-relationships
database-performance

How to fetch the row count for all tables in a SQL SERVER database

sql
database-performance
sql-scripts
database-maintenance

If statement in select (ORACLE)

sql
case-statement
oracle-nulls
sql-best-practices

Sql UPDATE SET one column to be equal to a value in a related table referenced by a different column?

sql
join
subqueries
transactions
explain.codes / Sql