Explain Codes LogoExplain Codes Logo

Sql

When do I need to use a semicolon vs a slash in Oracle SQL?

sql
best-practices
sql-commands
oracle-documentation

How to add time to DateTime in SQL

sql
datetime
sql-server
dateadd

What is numeric(18, 0) in SQL Server 2008 r2

sql
data-types
numeric-types
sql-server

Change a Nullable column to NOT NULL with Default Value

sql
default-value
data-consistency
sql-server

What is the difference between cube, rollup and groupBy operators?

sql
data-aggregation
sql-operators
database-performance

Sql Server Agent Job - Exists then Drop?

sql
transactional-safety
cursor
job-deletion

Athena Greater Than Condition in Date Column

sql
date-formatting
datetime-comparisons
sql-queries

Sql Update to the SUM of its joined values

sql
subqueries
aggregates
best-practices

How to enter special characters like "&" in oracle database?

sql
parameterization
bind-variables
sqlplus

How to get DATE from DATETIME Column in SQL?

sql
date-extraction
datetime
sql-performance

Mysql error 1241: Operand should contain 1 column(s)

sql
error-handling
sql-syntax
subqueries

Postgresql column 'foo' does not exist

sql
error-handling
postgresql
database-management

Oracle - what statements need to be committed?

sql
transaction-management
database-locks
commit-rollback

How to pass a null variable to a SQL Stored Procedure from C#.net code

sql
prompt-engineering
interview-preparation
best-practices

Conditional SQL count

sql
performance
best-practices
data-grouping

Getting the SQL from a Django QuerySet

sql
debugging
django-debug-toolbar
sql-inspection

Connecting to SQL Server using Windows authentication

sql
connection-string
sql-server
windows-authentication

How do I make a composite key with SQL Server Management Studio?

sql
composite-keys
sql-server-management-studio
database-design

The transaction log for the database is full

sql
transaction-log
database-management
performance-optimization

Rounding SQL DateTime to midnight

sql
date-functions
sql-server
datetime
explain.codes / Sql