Explain Codes LogoExplain Codes Logo

Sql

Sql: Alias Column Name for Use in CASE Statement

sql
subqueries
ctes
sql-queries

Finding the next available id in MySQL

sql
auto-increment
id-allocation
mysql-optimization

How to get last inserted id?

sql
sql-exceptions
resource-management
output-parameter

Replace null with 0 in MySQL

sql
null-replacement
mysql-functions
best-practices

Sql Error: ORA-01861: literal does not match format string 01861

sql
date-format
oracle-error
sql-best-practices

Sql Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=

sql
subquery
aggregate-functions
join

What's the best SQL datatype for storing JSON string?

sql
json-storage
sql-server
database-performance

Update multiple rows in Entity Framework from a list of ids

sql
bulk-operations
entity-framework
database-performance

Are left outer joins and left joins the same?

sql
join
best-practices
performance

Query comparing dates in SQL

sql
date-comparisons
sql-injection
best-practices

The backend version is not supported to design database diagrams or tables

sql
compatibility-level
database-design
sql-server

Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`

sql
best-practices
database-management
postgresql

Create date from day, month, year fields in MySQL

sql
date-format
mysql-optimization
performance-tuning

How to represent a data tree in SQL?

sql
database-design
data-modeling
sql-optimization

From Now() to Current_timestamp in PostgreSQL

sql
timestamp
postgresql
database-operations

How to find the users list in oracle 11g db?

sql
database-security
sql-queries
oracle-11g

C# Version Of SQL LIKE

sql
regex-pattern-matching
csharp-implementation
string-matching

Scope_identity() for GUIDs?

sql
guids
output-clause
t-sql

Mysql OPTIMIZE all tables?

sql
mysqlcheck
database-maintenance
optimization

How do I select all the columns from a table, plus additional columns like ROWNUM?

sql
window-functions
performance-tuning
best-practices
explain.codes / Sql