Explain Codes LogoExplain Codes Logo

Sql

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

Difference between BYTE and CHAR in column datatypes

sql
data-integrity
utf-8
schema-design

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

How to Enable Ad Hoc Distributed Queries

sql
ad-hoc-queries
security-measures
syntax-debugging
explain.codes / Sql