Explain Codes LogoExplain Codes Logo

Sql

Facebook database design?

sql
database-design
data-integrity
optimization

How to extract only the year from the date in SQL Server 2008?

sql
date-handling
sql-server
best-practices

How can I confirm a database is Oracle & what version it is using SQL?

sql
database-administration
sql-queries
oracle-database

Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc

sql
best-practices
performance
data-access

Finding duplicate values in a SQL table

sql
database-systems
group-by-clause
data-integrity

Oracle SQL how to remove time from date

sql
date-manipulation
sql-functions
best-practices

How to test an SQL Update statement before running it?

sql
transaction
update
sql-queries

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions

sql
pagination
offset-fetch
row-number

Mysql delete under safe mode

sql
temporary-tables
subqueries
mysql-workbench

Sql Identity (autonumber) is Incremented Even with a Transaction Rollback

sql
identity-mechanism
database-design
performance-optimization

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
explain.codes / Sql