Explain Codes LogoExplain Codes Logo

Sql

How to rethrow the same exception in SQL Server

sql
error-handling
try-catch
transactions

Why do we always prefer using parameters in SQL statements?

sql
parameterized-queries
sql-injection
stored-procedures

Trim is not a recognized built-in function name

sql
functions
best-practices
database-management

Difference between RESTRICT and NO ACTION

sql
foreign-key-constraints
database-design
transactional-integrity

Drop FUNCTION without knowing the number/type of parameters?

sql
drop-function
plpgsql
database-integrity

Mysql offset infinite rows

sql
offset-engineering
performance
best-practices

Generate SQL Create Scripts for existing tables with Query

sql
sql-server
database-scripting
sql-management-objects

Copy data from one existing row to another existing row in SQL?

sql
subqueries
joins
data-integrity

How to get ROWID in SQLite?

sql
join
best-practices
data-retrieval

View's SELECT contains a subquery in the FROM clause

sql
query-performance
sql-best-practices
database-optimization

How to find which views are using a certain table in SQL Server (2008)?

sql
database-administration
sql-server
dependency-management

Delete duplicate records in SQL Server?

sql
data-integrity
database-management
sql-queries

Why use "where 1=2" on a SQL CREATE TABLE syntax?

sql
database-schema
table-structure
dataless-table

Using "GO" within a transaction

sql
transactional-execution
batch-separators
variable-scope

How do I loop through a set of records in SQL Server?

sql
set-based-operations
performance-optimization
database-management

Subquery using Exists 1 or Exists *

sql
exists-clause
sql-server
performance-optimization

Mysql Select last 7 days

sql
date-time
interval
database-functions

Sql, Postgres OIDs, What are they and why are they useful?

sql
oid-management
postgresql-optimization
database-migration

How to delete from select in MySQL?

sql
performance
best-practices
join

Why use SQL database?

sql
database-optimization
sql-performance
orm-issues