Explain Codes LogoExplain Codes Logo

Sql

How to iterate over results of a query

sql
prompt-engineering
best-practices
sql-wizardry

Sql Management Studio won't recognize a table exists after scripted create

sql
intellisense
sql-server
database-management

How do parameterized queries help against SQL injection?

sql
sql-injection
parameterized-queries
database-security

Can you use an alias in the WHERE clause in mysql?

sql
subqueries
aggregate-functions
aliasing

How to delete duplicate rows without unique identifier

sql
delete-duplicates
postgresql
ctid

How to query GROUP BY Month in a Year

sql
group-by
date-aggregation
sql-functions

String or binary data would be truncated. The statement has been terminated

sql
data-truncation
sql-server
database-configuration

How do I find a default constraint using INFORMATION_SCHEMA?

sql
constraint-tracing
sys-views
sql-server

Escaping ampersand character in SQL string

sql
escape-mechanisms
sql-queries
string-concatenation

How to deal with SQL column names that look like SQL keywords?

sql
sql-keywords
sql-escaping
sql-design

What are best practices for multi-language database design?

sql
database-design
multilingual-database
sql-functions

How do I count columns of a table

sql
information-schema
metadata
database-structure

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