Explain Codes LogoExplain Codes Logo

Sql

Multiple INNER JOIN SQL ACCESS

sql
join
best-practices
sql-optimization

Why is query with phone = N'1234' slower than phone = '1234'?

sql
performance
best-practices
indexing

What's faster, SELECT DISTINCT or GROUP BY in MySQL?

sql
performance
indexing
query-optimizer

Using IF ELSE statement based on Count to execute different Insert statements

sql
best-practices
performance
functions

Alter TABLE without locking the table?

sql
database-migration
schema-change
online-ddl

Select NOT IN multiple columns

sql
join
performance
best-practices

Mysql incorrect key file for tmp table when making multiple joins

sql
tmp-table
mysql-configuration
performance-optimization

How can I introduce multiple conditions in LIKE operator?

sql
prompt-engineering
best-practices
performance

Executing a stored procedure within a stored procedure

sql
stored-procedures
transaction-control
error-propagation

Foreign key referring to primary keys across multiple tables?

sql
database-design
data-integrity
foreign-keys

Find all stored procedures that reference a specific column in some table

sql
sql-search
database-management
stored-procedures

How to compare dates in datetime fields in Postgresql?

sql
database
postgresql
date-range-comparisons

Calculating difference between two timestamps in Oracle in milliseconds

sql
interval
timestamp-arithmetic
oracle

Sql Server giving logins(users) db_owner access to database

sql
best-practices
security
scripting

Is There `StartsWith` or `Contains` in T-SQL with Variables?

sql
wildcards
performance
best-practices

How do I import a sql data file into SQL Server?

sql
import-data
sql-server
command-line-tool

How to Execute SQL Query without Displaying Results

sql
result-suppression
sql-commands
database-performance

Mysql Trigger after update only if row has changed

sql
database-performance
trigger-logic
sql-queries

How to find current transaction level?

sql
transaction-isolation
sql-server
database-management

Can I parameterize the table name in a prepared statement?

sql
sql-injection
dynamic-sql
security-best-practices
explain.codes / Sql