Explain Codes LogoExplain Codes Logo

Sql

How to skip certain database tables with mysqldump?

sql
mysqldump
database-backup
sql-commands

Primary key/foreign Key naming convention

sql
best-practices
database-design
naming-conventions

How do I convert a database row into a struct

sql
database-mapping
struct-conversion
sql-null-values

How to Concatenate Numbers and Strings to Format Numbers in T-SQL?

sql
null-value-management
data-type-casting
error-handling

Clustered vs Non-Clustered

sql
index-design
performance-tuning
database-administration

How to do INSERT into a table records extracted from another table

sql
insert-into-select
sql-queries
data-aggregation

Sql update fields of one table from fields of another one

sql
dynamic-sql
postgresql
database-queries

Mysql comparison with null value

sql
null-safe-operator
coalesce-function
null-handling

How to check if a field is null or empty in MySQL?

sql
prompt-engineering
best-practices
performance

Adding an identity to an existing column

sql
identity-insert
database-migration
sql-server

Group query results by month and year in PostgreSQL

sql
database
date-formatting
group-by

How to group by hour in PostgreSQL using "time" field?

sql
date_trunc
date_part
time-zone

Postgresql visual interface similar to phpMyAdmin?

sql
database-administration
postgresql-tools
interface-comparison

Foreign Key to non-primary key

sql
foreign-key
database-design
data-integrity

Search for a string in all tables, rows, and columns of a DB

sql
full-text-indexing
sql-performance
database-search

Sql Group By with an Order By

sql
group-by
order-by
sql-best-practices

How to turn IDENTITY_INSERT on and off using SQL Server 2008?

sql
sql-server
identity-insert
bulk-insert

Unable to drop and create database in SQL Server

sql
database-management
sql-server
best-practices

Changing the size of a column referenced by a schema-bound view in SQL Server

sql
data-migration
schema-binding
database-design

Can't drop table: A foreign key constraint fails

sql
foreign-key-constraints
database-management
data-integrity
explain.codes / Sql