Explain Codes LogoExplain Codes Logo

Sql

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

Select data from date range between two dates

sql
date-range
between
performance

Truncate (not round) decimal places in SQL Server

sql
truncation
round
best-practices

How to return only the Date from a SQL Server DateTime datatype

sql
date-formatting
performance
null-handling

What is the most efficient/elegant way to parse a flat table into a tree?

sql
recursive-queries
closure-tables
path-enumeration

Postgresql - query from bash script as database user 'postgres'

sql
bash-scripting
dynamic-sql
error-handling

What is the difference between HAVING and WHERE in SQL?

sql
having
where
query-optimization

Most efficient T-SQL way to pad a varchar on the left to a certain length?

sql
padding
performance
data-integrity

How can I copy data from one column to another in the same table?

sql
data-type-conversion
update-query
null-handling

How to Enable Ad Hoc Distributed Queries

sql
ad-hoc-queries
security-measures
syntax-debugging

Generate class from database table

sql
class-generation
schema-joins
dataannotations

How can I list all foreign keys referencing a given table in SQL Server?

sql
foreign-keys
referential-integrity
database-scripts
explain.codes / Sql