Explain Codes LogoExplain Codes Logo

Sql

How to design a database for User Defined Fields?

sql
database-design
performance-optimization
data-structure

Equivalent of Oracle's RowID in SQL Server

sql
join
best-practices
performance

Difference between View and table in SQL

sql
data-management
database-design
performance-optimization

Are Views automatically updated

sql
indexed-views
database-performance
view-refresh

How can I check if a View exists in a Database?

sql
database-views
sql-server
best-practices

How to generate the whole database script in MySQL Workbench?

sql
database-backup
mysql-workbench
sql-scripts

How to export output in "real" CSV format in SQL Server Management Studio(SSMS)?

sql
prompt-engineering
best-practices
data-types

Standard use of 'Z' instead of NULL to represent missing data?

sql
best-practices
data-management
database-design

How to include "zero" / "0" results in COUNT aggregate?

sql
join
aggregate-functions
subqueries

Get month name from date in Oracle

sql
date-formatting
oracle-sql
best-practices

How to use multiple LEFT JOINs in SQL?

sql
join
performance
best-practices

Get last record of a table in Postgres

sql
prompt-engineering
best-practices
performance

Mysql Group By and Sum total value of other column

sql
sql-best-practices
sql-queries
sql-tips

Comparing results with today's date?

sql
database-specific-functions
indexing-performance
date-manipulation

How can I work with SQL NULL values and JSON in a good way?

sql
json-marshalling
custom-types
null-values

Is there any difference between GROUP BY and DISTINCT

sql
distinct-vs-group-by
sql-engine
performance-optimization

Perform insert for each row taken from a select?

sql
set-based-operations
cursor-based-methods
sql-injection

Sql Query for Logins

sql
sql-injection
query-optimization
index-usage

Cannot Resolve Collation Conflict

sql
collation-conflict
sql-server
database-management

Concatenate string with field value in MySQL

sql
join
concat
performance
explain.codes / Sql