Explain Codes LogoExplain Codes Logo

Sql

Database Naming Conventions by Microsoft?

sql
naming-conventions
readability
best-practices

Sql Server SELECT INTO @variable?

sql
table-variables
temporary-tables
data-manipulation

Sql- Ignore case while searching for a string

sql
case-insensitivity
collation
wildcards

Mysql: Update Field Only if Condition Is Met

sql
conditional-updates
case-statement
data-integrity

# "where 1=1" statement

sql
dynamic-sql
query-optimization
sql-injection

Run raw SQL in migration

sql
raw-sql
migrations
database

Group by date only on a Datetime column

sql
group-by
date-filtering
performance

Mysql :: insert into table, data from another table?

sql
insert
data-migration
performance

Sqlplus statement from the command line

sql
sqlplus
security
complex-queries

Sort by column ASC, but NULL values first?

sql
nulls-first
query-optimization
case-statement

Difference between Select Unique and Select Distinct

sql
select-distinct
data-integrity
unique-constraints

Generate a resultset of incrementing dates in T-SQL

sql
date-generation
performance
common-table-expressions

Get mySQL MONTH() to use leading zeros?

sql
date-format
leading-zeros
time-zones

Mysql CREATE FUNCTION Syntax

sql
functions
best-practices
error-handling

How to select rows that have the current day's timestamp?

sql
date-comparison
indexing
execution-plans

How do I ignore ampersand characters in a SQL script running from SQL Plus?

sql
ampersand
set-define
best-practices

Execute SQL script from command line

sql
sqlcmd
automation
backup

Rails 3 Execute Custom SQL Query Without a Model

sql
raw-sql
active-record
sql-injection

Postgresql Crosstab Query

sql
crosstab
data-integrity
json-functions

How to query a json column for empty objects?

sql
json
indexing
performance
explain.codes / Sql