Explain Codes LogoExplain Codes Logo

Sql

What is Full Text Search vs LIKE

sql
prompt-engineering
best-practices
indexing

How to delete multiple rows in SQL where id = (x to y)

sql
delete-operations
sql-performance
sql-best-practices

How do I find a "gap" in running counter with SQL?

sql
prompt-engineering
join
performance

Why do people hate SQL cursors so much?

sql
best-practices
performance
join

Updating columns with a sequence number mysql

sql
join
performance
best-practices

Nested select statement in SQL Server

sql
subqueries
data-aggregation
query-optimization

Mysql Cannot Add Foreign Key Constraint

sql
foreign-key-constraints
mysql-troubleshooting
database-design

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement

sql
database-administration
sql-server
database-maintenance

Sql SELECT multi-columns INTO multi-variable

sql
sql-scripts
variable-assignment
null-handling

Find Nearest Latitude/Longitude with an SQL Query

sql
geometric-operations
database-performance
sql-injection

Sql Server: Is it possible to insert into two tables at the same time?

sql
transaction
set-based-operations
database-performance

Is there a performance difference between CTE, Sub-Query, Temporary Table or Table Variable?

sql
performance
best-practices
optimization

Row-level trigger vs statement-level trigger

sql
data-integrity
trigger-execution
database-maintenance

Group BY to combine/concat a column

sql
group-by
concatenation
sql-server

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