Explain Codes LogoExplain Codes Logo

Sql

How to find duplicate records in PostgreSQL

sql
prompt-engineering
best-practices
join

Sql Server, division returns zero

sql
decimal-data-types
division-by-zero
sql-server-performance

Sql Server - Return value after INSERT

sql
best-practices
sql-server
output-clause

T-sql split string

sql
string-split
sql-server
delimiter

Tsql - How to use GO inside of a BEGIN .. END block?

sql
dynamic-sql
try-catch
sql-execution

How to SELECT WHERE NOT EXIST using LINQ?

sql
linq-transformation
sql-linq
entity-framework

How to select all records from one table that do not exist in another table?

sql
join
performance
best-practices

How do I create a foreign key in SQL Server?

sql
foreign-key
database-design
referential-integrity

Altering column size in SQL Server

sql
best-practices
data-integrity
sql-syntax

How to do the Recursive SELECT query in MySQL?

sql
recursive-procedures
best-practices
stored-procedures

How to update selected rows with values from a CSV file in Postgres?

sql
best-practices
data-integrity
performance

Get list of all tables in Oracle?

sql
database-views
oracle-queries
metadata

Set database from SINGLE USER mode to MULTI USER

sql
database-management
sql-server
multi-user-mode

How to select a column name with a space in MySQL

sql
best-practices
sql-syntax
database-management

Detect if value is number in MySQL

sql
regexp
mysql
numeric-patterns

How to retrieve JSON data from MySQL?

sql
json-handling
mysql-performance
database-normalization

Insert statement conflicted with the FOREIGN KEY constraint - SQL Server

sql
foreign-key
database-design
error-handling

Sql try/catch rollback/commit - preventing erroneous commit after rollback

sql
error-handling
transaction-management
sql-server

How to write "not in ()" sql query using join

sql
join
best-practices
performance

How to install localdb separately?

sql
localdb
sql-server-express
database-management
explain.codes / Sql