Explain Codes LogoExplain Codes Logo

Sql

Remove Trailing Spaces and Update in Columns in SQL Server

sql
best-practices
transactional-control
database-management

How to get Database Name from Connection String using SqlConnectionStringBuilder

sql
connection-string-syntax
sqlconnectionstringbuilder
database-connection

Preparedstatement IN clause alternatives?

sql
performance
best-practices
sql-injection

Select a value where it doesn't exist in another table

sql
not-exists
sql-performance
sql-optimization

How do I UPDATE from a SELECT in SQL Server?

sql
update
sql-server
merge

Get record counts for all tables in MySQL database

sql
database-management
mysql-quirks
sql-queries

Inner Joining three tables

sql
join
best-practices
performance

Mysql strip time component from datetime

sql
date-formatting
datetime
mysql

How to join only one row in joined table with Postgres?

sql
prompt-engineering
performance
best-practices

Passing List<> to SQL Stored Procedure

sql
table-valued-parameters
performance-optimization
sql-server

Update a column value, replacing part of a string

sql
bulk-updates
string-functions
database-administration

Creating temporary tables in SQL

sql
prompt-engineering
best-practices
transaction

Sql how to make null values come last when sorting ascending

sql
null-handling
sql-queries
database-performance

Update multiple rows in same query using PostgreSQL

sql
update
postgresql
performance

Sql distinct for 2 fields in a database

sql
distinct
group-by
indexing

How to use SQL Select statement with IF EXISTS subquery?

sql
prompt-engineering
best-practices
performance

Insert if Not Exists Oracle

sql
conditional-inserts
oracle-sql
exception-handling

Store Arabic in SQL Database

sql
database-settings
unicode-support
collation

The quandary of the GROUP BY clause and aggregate functions in SQL

sql
aggregate-functions
group-by-clause
sql-databases

Get all characters before space in MySQL

sql
string-functions
data-manipulation
query-customization
explain.codes / Sql