Explain Codes LogoExplain Codes Logo

Sql

Sql Server 2008- Get table constraints

sql
constraints
foreign-keys
data-integrity

How to reset AUTO_INCREMENT in MySQL

sql
auto-increment
data-integrity
phpmyadmin

Syntax of for-loop in SQL Server

sql
for-loop
offset-fetch
performance

Use string contains function in oracle SQL query

sql
pattern-matching
contains
regexp

Convert Xml to Table SQL Server

sql
xml
openxml
xquery

What does Include() do in LINQ?

sql
include
eager-loading
lazy-loading

Declare a variable in a PostgreSQL query

sql
session-variables
plpgsql
temporary-tables

Find records with a date field in the last 24 hours

sql
date-functions
performance
timezones

Sql Server: Get data for only the past year

sql
date-filtering
performance
dynamic-queries

Passing multiple values for a single parameter in Reporting Services

sql
string-split
custom-functions
sql-injection

What are the use cases for selecting CHAR over VARCHAR in SQL?

sql
data-types
performance
storage-optimization

How do I rename an Index in MySQL

sql
indexing
database-maintenance
foreign-keys

Group BY having MAX date

sql
query-optimization
group-by
joins

What is the purpose of constraint naming

sql
constraint-naming
best-practices
database-integration

Ordering by the order of values in a SQL IN() clause

sql
sorting
best-practices
joins

How can I find which tables reference a given table in Oracle SQL Developer?

sql
case-sensitivity
foreign-keys
querying

Select where count of one field is greater than one

sql
group-by
having
subquery

How to insert table values from one database to another database?

sql
data-transfer
permissions
network-issues

How can I do an UPDATE statement with JOIN in SQL Server?

sql
update
join
performance

Oracle Differences between NVL and Coalesce

sql
nvl
coalesce
performance
explain.codes / Sql