Explain Codes LogoExplain Codes Logo

Sql

Alter data type of a column to serial

sql
prompt-engineering
best-practices
sequence-management

Declare local variables in PostgreSQL?

sql
best-practices
sql-variables
plpgsql

Convert Date format into DD/MMM/YYYY format in SQL Server

sql
date-formatting
sql-server
date-conversion

Copy table structure to a new table in SQLite3

sql
database-management
sqlite
schema-management

Sql-server: Error - Exclusive access could not be obtained because the database is in use

sql
exclusive-access
database-restoration
backup-file-path

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