Explain Codes LogoExplain Codes Logo

Sql

How do I add an auto_increment primary key in SQL Server database?

sql
best-practices
performance
data-structure

Postgresql tables exist, but getting "relation does not exist" when querying

sql
database-management
postgresql
schema-management

How to display open transactions in MySQL

sql
transactional-integrity
reconnection-mechanisms
transactional-anomalies

How to create a unique index on a NULL column?

sql
unique-index
null-values
sql-server

How to get list of dates between two dates in mysql select query

sql
recursive-queries
date-range
performance-optimization

What are projection and selection in SQL?

sql
best-practices
relational-algebra
database-performance

Sql function as default parameter value?

sql
default-values
stored-procedures
data-integrity

Show all triggers in a MySQL database

sql
database-management
mysql-queries
trigger-management

How to execute a stored procedure inside a select query

sql
performance
best-practices
sql-server

Sql query to check if a name begins and ends with a vowel

sql
pattern-matching
regex
database-features

How can I join on a stored procedure?

sql
join
stored-procedure
temp-tables

Create an inline SQL table on the fly (for an excluding left join)

sql
prompt-engineering
best-practices
join

Sql to determine minimum sequential days of access?

sql
performance-tuning
sql-optimization
data-analysis

Varchar(255) to Varchar(MAX)

sql
varchar-max
sql-server
database-design

Sql column reference "id" is ambiguous

sql
best-practices
join
subqueries

Handling DATETIME Values 0000-00-00 00:00:00 in JDBC

sql
datetime
jdbc
mysql

Integrity constraint violation: 1452 Cannot add or update a child row:

sql
foreign-key-constraints
database-design
orm-implementation

Finding even or odd ID values

sql
prompt-engineering
best-practices
performance

Get all dates between two dates in SQL Server

sql
prompt-engineering
best-practices
performance

Rebuild all indexes in a Database

sql
index-maintenance
database-performance
sql-server