Explain Codes LogoExplain Codes Logo

Sql

Database Design for Tagging

sql
database-design
query-optimization
indexing

Implement paging (skip / take) functionality with this query

sql
pagination
database-performance
best-practices

Identity_insert is set to OFF - How to turn it ON?

sql
identity-insert
sql-best-practices
data-migration

How to select last 6 months from news table using MySQL

sql
datetime
performance
best-practices

Generating random strings with T-SQL

sql
prompt-engineering
best-practices
performance

Why does NULL = NULL evaluate to false in SQL server

sql
null-comparison
three-valued-logic
best-practices

How to use DISTINCT and ORDER BY in same SELECT statement?

sql
sql-standards
subqueries
joins

What's the difference between TRUNCATE and DELETE in SQL

sql
transaction-logs
redo-undo-data
bulk-operations

Select a column in SQL not in Group By

sql
join
subqueries
ctes

Sql DELETE with INNER JOIN

sql
best-practices
join
foreign-key-constraints

T-sql and the WHERE LIKE %Parameter% clause

sql
prompt-engineering
best-practices
performance

Convert a string to int using SQL query

sql
data-types
conversion
best-practices

Count the occurrences of DISTINCT values

sql
distinct
count
group-by

How to create a new schema/new user in Oracle Database 11g?

sql
database-management
schema-creation
oracle-database

C# SQL Server - Passing a list to a stored procedure

sql
tvp
parameterized-queries
sql-injection

How can I get column names from a table in SQL Server?

sql
metadata
information-schema
sql-server

How to convert all tables from MyISAM into InnoDB?

sql
database-conversion
mysql
innodb

How do I use variables in Oracle SQL Developer?

sql
bind-variables
substitution-variables
plsql

Why is SELECT * considered harmful?

sql
best-practices
performance
database-design

What is the difference between single and double quotes in SQL?

sql
best-practices
sql-standards
database-objects
explain.codes / Sql