Explain Codes LogoExplain Codes Logo

Sql

How many rows in a database are TOO MANY?

sql
performance-optimization
database-optimization
indexing

Can I create a named default constraint in an add column statement in SQL Server?

sql
default-constraints
sql-server
database-design

The object 'DF__*' is dependent on column '*' - Changing int to double

sql
database-operations
error-handling
data-types

Why is there no PRODUCT aggregate function in SQL?

sql
sql-server
custom-aggregates
workarounds

Is this the proper way to do boolean test in SQL?

sql
boolean-logic
database-quirks
sql-standards

Delete SQL rows where IDs do not have a match from another table

sql
delete-operations
sql-patterns
database-management

Mysql SELECT IF statement with OR

sql
prompt-engineering
best-practices
performance

How to convert DateTime to VarChar

sql
datetime-conversion
sql-functions
date-formatting

On DELETE CASCADE in sqlite3

sql
foreign-keys
database-design
sqlite

How to add 'ON DELETE CASCADE' in ALTER TABLE statement

sql
best-practices
data-integrity
referential-integrity

Get the latest date from grouped MySQL data

sql
join
best-practices
performance

What is the syntax for an inner join in LINQ to SQL?

sql
join
linq
sql-server

How to count the number of instances of each foreign-key ID in a table?

sql
join
performance
best-practices

Select Row number in postgres

sql
window-functions
row-number
pagination

How to insert an empty line to SQL table?

sql
database-management
data-insertion
sql-commands

How to get the next auto-increment ID in MySQL

sql
best-practices
data-integrity
sql-injection

Sql - IF EXISTS UPDATE ELSE INSERT INTO

sql
upsert
sql-injection
database-connections

Mysql CONCAT returns NULL if any field contain NULL

sql
null-handling
concat-function
coalesce-function

How can I change NULL to 0 when getting a single value from a SQL function?

sql
prompt-engineering
best-practices
data-type-compatibility

How do I copy data from one table to another in postgres using copy command

sql
data-transfer
copy-command
postgres