Explain Codes LogoExplain Codes Logo

Sql

Insert statement conflicted with the FOREIGN KEY constraint - SQL Server

sql
foreign-key
database-design
error-handling

Sql try/catch rollback/commit - preventing erroneous commit after rollback

sql
error-handling
transaction-management
sql-server

How to write "not in ()" sql query using join

sql
join
best-practices
performance

How to install localdb separately?

sql
localdb
sql-server-express
database-management

How to check which locks are held on a table

sql
database-management
lock-management
sql-queries

How to use Oracle ORDER BY and ROWNUM correctly?

sql
prompt-engineering
best-practices
performance

How do I query for all dates greater than a certain date in SQL Server?

sql
date-formatting
sql-functions
date-comparisons

Double colon `::` notation in SQL

sql
type-casting
date-handling
sql-dialects

Insert results of a stored procedure into a temporary table

sql
temp-tables
stored-procedures
performance-optimization

Sql update query using joins

sql
update-query
sql-joins
sql-aliases

How to increase SQL*Plus column output length?

sql
best-practices
data-integrity
performance

Linq to SQL - Left Outer Join with multiple join conditions

sql
linq
join
performance

Aggregate function in SQL WHERE-Clause

sql
aggregate-functions
subqueries
join

How can I add a column that doesn't allow nulls in a Postgresql database?

sql
data-integrity
default-values
sql-queries

How to rename a table in SQLite 3.0?

sql
database-management
data-verification
sql-commands

Load DATA LOCAL, How do I skip the first line?

sql
load-data-local
mysql
data-import

Inserting text string with hex into PostgreSQL as a bytea

sql
bytea
hex
postgresql

Pass In "WHERE" parameters to PostgreSQL View?

sql
set-returning-functions
dynamic-filtering
postgresql-views

Simple way to calculate median with MySQL

sql
join
best-practices
performance

How to check if a stored procedure exists before creating it

sql
best-practices
programming-practices
sql-server
explain.codes / Sql