Explain Codes LogoExplain Codes Logo

Sql

Can you have if-then-else logic in SQL?

sql
prompt-engineering
best-practices
performance

Sql Delete Records within a specific Range

sql
data-recovery
sql-queries
database-management

Getting return value from stored procedure in C#

sql
stored-procedures
best-practices
error-handling

Is it faster to access data from files or a database server?

sql
benchmarking
database-performance
data-access-strategies

Imply bit with constant 1 or 0 in SQL Server

sql
best-practices
data-types
typecasting

Mysql: How to Add One Day to Datetime Field in Query

sql
datetime
interval
date-add

Get week day name from a given month, day, and year individually in SQL Server

sql
date-parsing
sql-server
date-functions

Selecting unique values from a column

sql
distinct
performance
best-practices

What's the best way to select the minimum value from several columns?

sql
best-practices
performance
join

How to replace a string in a SQL Server Table Column

sql
best-practices
data-integrity
sql-server

How to get script of SQL Server data?

sql
script-generation
data-consistency
sql-server

Linked List in SQL

sql
linked-list
sql-queries
database-design

Mysql LEFT JOIN 3 tables

sql
join
subqueries
left-join

Lock Escalation - What's happening here?

sql
lock-escalation
concurrency
performance

How to implement LIMIT with SQL Server?

sql
performance
best-practices
join

Postgres: How to do Composite keys?

sql
data-integrity
constraints
composite-keys

Sql Query Distinct with Row_Number

sql
prompt-engineering
best-practices
performance

Use current date as default value for a column

sql
default-values
database-integrity
schema-management

How to Return Rows from Left Table Not Found in Right Table?

sql
join
performance
best-practices

Table Naming Dilemma: Singular vs. Plural Names

sql
database-design
naming-conventions
sql-best-practices
explain.codes / Sql