Explain Codes LogoExplain Codes Logo

Sql

Sort the rows according to the order specified in WHERE IN clause

sql
case-statements
sql-sorting
custom-order

How to include a PHP variable inside a MySQL statement

sql
sql-injection
prepared-statements
pdo

What is the meaning of <> in MySQL query?

sql
join
best-practices
database

How to get the difference in years between two dates in SQL?

sql
timestampdiff
datediff
sql-performance

Does Dapper support the like operator?

sql
parameterization
sql-injection
database-behavior

Select rows with id having an even number

sql
sql-performance
sql-best-practices
sql-queries

Find rows that have the same value on a column in MySQL

sql
join
dataframe
performance

Log the actual SQL query using ActiveRecord with Yii2?

sql
logging
active-record
debugging

Why do I get "A cursor with the name already exists"?

sql
cursor-management
sql-server
best-practices

What does a transaction around a single statement do?

sql
transactional-consistency
performance-overhead
data-integrity

Mysql : Transaction within a procedure

sql
transaction-management
error-handling
best-practices

How to Suppress the SELECT Output of a Stored Procedure called from another Stored Procedure in SQL Server?

sql
performance
sql-server
output-suppression

Passing Output parameters to stored procedures using Dapper in C# code

sql
dynamic-parameters
stored-procedures
dapper

How to populate a table with a range of dates?

sql
prompt-engineering
join
best-practices

Need to list all triggers in SQL Server database with table name and table's schema

sql
trigger-engineering
database-security
permissions

How to execute an IN lookup in SQL using Golang?

sql
prepared-statements
sql-injection
database-security

How to close existing connections to a DB

sql
database-management
sql-server
connection-management

Count based on condition in SQL Server

sql
conditional-counting
sql-queries
database-optimization

How to copy a row and insert in same table with an autoincrement field in MySQL?

sql
best-practices
performance
join

Multiple aggregate functions in HAVING clause

sql
prompt-engineering
best-practices
conditional-aggregates