Explain Codes LogoExplain Codes Logo

Sql

Sql Statement indentation good practice

sql
best-practices
code-maintenance
sql-formating

Mysql INSERT INTO ... VALUES and SELECT

sql
database-integrity
data-transfer
sql-optimization

How to create a table from select query result in SQL Server 2008

sql
join
data-types
best-practices

How to compare two SQLite databases on Linux

sql
prompt-engineering
diff
database-comparison

Order by COUNT per value

sql
join
prompts-engineering
best-practices

Sql Server: How to check if CLR is enabled?

sql
sql-server
clr
database-permissions

Sql set values of one column equal to values of another column in the same table

sql
join
data-integrity
update-queries

Insert/ Update random date in MySQL

sql
randomization
date-functions
mysql-queries

How do I find the largest value in a column in postgres sql?

sql
prompt-engineering
best-practices
performance

Sql DATEPART(dw,date): Setting Monday as 1 and Sunday as 7

sql
datepart
weekday
sql-server

How to get calendar Quarter from a date in TSQL

sql
prompt-engineering
join
cte

Select one column if the other is null

sql
null-handling
sql-functions
data-integrity

How to get the first two characters of a string in an Oracle query?

sql
prompt-engineering
functions
best-practices

Sql select join: is it possible to prefix all columns as 'prefix.*'?

sql
join
best-practices
database-design

Use one CTE many times

sql
prompt-engineering
best-practices
data-integrity

Proper way of checking if row exists in table in PL/SQL block

sql
prompt-engineering
best-practices
debugging

Passing table name as a parameter in psycopg2

sql
sql-injection
prepared-statements
parametrized-queries

Get stored procedure parameters by either C# or SQL?

sql
sql-server
parameter-discovery
csharp

How do I enable the MySQL slow query log?

sql
performance
best-practices
tools

Know relationships between all the tables of database in SQL Server

sql
database-diagrams
information-schema
recursive-relationships
explain.codes / Sql