Explain Codes LogoExplain Codes Logo

Sql

Mixing explicit and implicit joins fails with "There is an entry for table ... but it cannot be referenced from this part of the query"

sql
best-practices
join
sql-engine

What is the syntax meaning of RAISERROR()

sql
error-handling
sql-server
database-management

Select group of rows that match all items in a list

sql
subquery
join
performance

How to detect if a string contains at least a number?

sql
pattern-matching
sql-server
postgresql

Optimistic locking in MySQL

sql
transaction-management
optimistic-locking
database-isolation-levels

Sql Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE

sql
best-practices
performance
sql-server

Can select * usage ever be justified?

sql
best-practices
performance
data-migration

Update `int` column in a table with unique incrementing values

sql
update
incrementing-values
sql-queries

Temporary table in SQL server causing 'There is already an object named' error

sql
temp-tables
error-handling
sql-server

Sql Server check case-sensitivity?

sql
collation
sql-server
database-management

T-sql: Round to nearest 15 minute interval

sql
prompt-engineering
best-practices
dataframe

Cannot drop table users because other objects depend on it

sql
database-management
sql-queries
database-design

What are the uses for Cross Join?

sql
join
database-performance
data-management

Why does SQL Server keep creating a DF constraint?

sql
default-constraints
sql-server
database-management

Mysql - How to quit/exit from stored procedure

sql
best-practices
error-handling
stored-procedures

Mysql ON DUPLICATE KEY UPDATE for multiple rows insert in single query

sql
bulk-insertions
sql-injection
decimal-values

How do I subtract using SQL in MYSQL between two date time values and retrieve the result in minutes or seconds?

sql
timestampdiff
timediff
time_to_sec

Count distinct values

sql
distinct-values
sql-queries
data-visualization

Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio

sql
prompt-engineering
best-practices
dataframe

In MySQL, how to copy the content of one table to another table within the same database?

sql
data-transfer
sql-queries
database-management