Explain Codes LogoExplain Codes Logo

Sql

Mysql - Selecting data from multiple tables all with same structure but different data

sql
database-engine
query-optimization
data-management

What are good alternatives to SQL (the language)?

sql
database-language
sql-alternatives
data-access

What SQLite column name can be/cannot be?

sql
best-practices
database-design
sql-optimization

Reference alias (calculated in SELECT) in WHERE clause

sql
prompt-engineering
best-practices
join

Only inserting a row if it's not already there

sql
database-management
data-integrity
concurrency-control

How to Convert PostgreSQL 9.4's jsonb Type to Float

sql
jsonb
casting
postgresql

Add a row number to result set of a SQL query

sql
window-functions
row-numbering
sql-performance

How to report an error from a SQL Server user-defined function

sql
custom-error-handling
udf
sql-server

How can I do a BEFORE UPDATED trigger with sql server?

sql
best-practices
data-integrity
trigger-optimization

How to escape simple SQL queries in C# for SqlServer

sql
sql-injection
parameterized-queries
sql-security

Mysql where NOT IN name array?

sql
sql-injection
prepared-statements
database-security

How to add a variable number of hours to a date in PostgreSQL?

sql
interval-data-type
timestamp
date

How to subtract 30 days from the current date using SQL Server

sql
date-manipulation
datetime
sql-functions

Entity Framework throws exception - Invalid object name 'dbo.BaseCs'

sql
entity-framework
database-configuration
error-handling

How to aggregate values into an array in PostgreSQL?

sql
array-aggregation
postgresql
data-mining

Convert date to YYYYMM format

sql
date-formatting
sql-server
performance-optimization

Use a LIKE statement on SQL Server XML Datatype

sql
xml
performance
full-text search

Get affected rows on ExecuteNonQuery

sql
transactions
resource-management
sql-operations

Mysql update query with sub query

sql
subqueries
join
performance

What datatype to use when storing latitude and longitude data in SQL databases?

sql
data-integrity
geospatial-data
database-optimization
explain.codes / Sql