Explain Codes LogoExplain Codes Logo

Sql

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

Sql Statement indentation good practice

sql
best-practices
code-maintenance
sql-formating

Mysql INSERT INTO ... VALUES and SELECT

sql
database-integrity
data-transfer
sql-optimization

How to create a table from select query result in SQL Server 2008

sql
join
data-types
best-practices

How to compare two SQLite databases on Linux

sql
prompt-engineering
diff
database-comparison

Order by COUNT per value

sql
join
prompts-engineering
best-practices

Sql Server: How to check if CLR is enabled?

sql
sql-server
clr
database-permissions

Sql set values of one column equal to values of another column in the same table

sql
join
data-integrity
update-queries

Insert/ Update random date in MySQL

sql
randomization
date-functions
mysql-queries
explain.codes / Sql