Explain Codes LogoExplain Codes Logo

Sql

A simple way to sum a result from UNION in MySQL

sql
join
best-practices
performance

How to identify whether the table has an identity column

sql
sql-server
identity-columns
system-catalog-views

Can you delete data from influxdb?

sql
data-retention
influxdb
database-management

Why doesn't Oracle tell you which table or view does not exist?

sql
error-handling
debugging
sql-queries

What's the best SQLite data type for a long string

sql
data-types
sqlite
string-storage

How to improve performance for datetime filtering in SQL Server?

sql
indexing
performance
execution-plan

Error importing SQL dump into MySQL: Unknown database / Can't create database

sql
mysql-errors
importing-data
database-privileges

What SQL coding standard do you follow?

sql
best-practices
sql-optimization
database-security

Can't change table design in SQL Server 2008

sql
database-design
sql-server
data-loss-prevention

Sql Server Update Group by

sql
performance
best-practices
join

Return multiple fields as a record in PostgreSQL with PL/pgSQL

sql
best-practices
performance
functions

A strange operation problem in SQL Server: -100/-100*10 = 0

sql
operator-precedence
sql-server-behavior
best-practices

What represents a double in sql server?

sql
data-types
decimal
precision

Mysql variable format for a "NOT IN" list of values

sql
dynamic-sql
sql-performance
mysql-optimization

Get the SQL query result without the table format

sql
mysql-flags
output-customization
batch-mode

Can I pass column name as input parameter in a SQL stored procedure

sql
sql-injection
dynamic-sql
parameterization

Invalid use of side-effecting operator insert within a function

sql
best-practices
performance
error-handling

Mysql: Can't create table (errno: 150)

sql
foreign-keys
database-design
mysql-error

Sql Server silently truncates varchar's in stored procedures

sql
data-integrity
error-handling
sql-server

C# guid and SQL uniqueidentifier

sql
guid
sql-server
entity-framework
explain.codes / Sql