Explain Codes LogoExplain Codes Logo

Sql

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

How to resolve ambiguous column names when retrieving results?

sql
join
best-practices
data-discrepancies

How to detect query which holds the lock in Postgres?

sql
lock-investigation
postgres-queries
database-performance

Postgres - Function to return the intersection of 2 ARRAYs?

sql
array-operations
postgresql
intersection

What is the difference between ";" and "GO" in T-SQL?

sql
sql-server
t-sql
batch-commands

Oracle insert from select into table with more columns

sql
best-practices
join
data-type-compatibilities

Alter a MySQL column to be AUTO_INCREMENT

sql
database-management
mysql-commands
data-structures

Postgresql: using a calculated column in the same query

sql
join
performance
best-practices

Create a one to many relationship using SQL Server

sql
foreign-key
join
database-design

Mysql insert random datetime in a given datetime range

sql
randomness
datetime
performance

T-sql: Using a CASE in an UPDATE statement to update certain columns depending on a condition

sql
dynamic-sql
update-statements
error-handling

Mysql concatenation operator

sql
concatenation
sql-mode
concat-function
explain.codes / Sql