Explain Codes LogoExplain Codes Logo

Sql

How to find a table having a specific column in postgresql

sql
database-administration
postgresql
sql-queries

How do I drop table variables in SQL-Server? Should I even do this?

sql
best-practices
performance
tempdb

Export specific rows from a PostgreSQL table as INSERT SQL script

sql
prompt-engineering
best-practices
data-types

Most efficient way to store IP Address in MySQL

sql
database-profiling
performance-bottlenecks
indexing

Sql error "ORA-01722: invalid number"

sql
data-validation
exception-handling
best-practices

How can I import a JSON file into PostgreSQL?

sql
json
postgresql
data-manipulation

How to capitalize the first letter of each word in a string in SQL Server

sql
prompt-engineering
best-practices
functions

Get top n records for each group of grouped results

sql
prompt-engineering
best-practices
performance

How to generate a range of numbers between two numbers?

sql
functions
performance
best-practices

How can I convert a Sql Server 2008 DateTimeOffset to a DateTime

sql
datetime-conversion
timezone-issues
sql-server-2008

Ora-00979 not a group by expression

sql
join
group-by
sql-best-practices

Is there a version control system for database structure changes?

sql
database-migrations
version-control
database-structure

Change Primary Key

sql
database-operations
primary-key-change
sql-queries

Subquery in FROM must have an alias

sql
subquery
sql-queries
database-queries

How to get a list column names and datatypes of a table in PostgreSQL?

sql
database-management
postgresql
sql-queries

Row_number() in MySQL

sql
prompt-engineering
join
best-practices

Is there a way to define a named constant in a PostgreSQL query?

sql
constants
performance
best-practices

Sql Server Ignore Case in a Where Expression

sql
collate
case-insensitivity
sql-server

Adding a column description

sql
best-practices
database-management
sql-scripts

Sqlite: Select Into?

sql
data-migration
database-design
performance-optimization
explain.codes / Sql