Explain Codes LogoExplain Codes Logo

Sql

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

Incorrect syntax near ''

sql
prompt-engineering
best-practices
sql-encoding

Select from nothing?

sql
prompt-engineering
best-practices
sql-syntax

Alter TABLE DROP COLUMN failed because one or more objects access this column

sql
prompt-engineering
interview-preparation
best-practices

Is there a way to get a list of all current temporary tables in SQL Server?

sql
temp-tables
sql-server
metadata-tables

Sql Case Expression Syntax?

sql
conditional-aggregation
case-expressions
sql-queries
explain.codes / Sql