Explain Codes LogoExplain Codes Logo

Sql

How do I batch sql statements with package database/sql

sql
batch-insert
database-performance
sql-optimization

Just get column names from a Hive table

sql
hive-command
column-names
table-metadata

Passing an array of parameters to a stored procedure

sql
tvp
xml-serialization
dynamic-sql

How to return default value from an SQL query

sql
sql-performance
best-practices
query-optimization

Oracle 'Partition By' and 'Row_Number' keyword

sql
prompt-engineering
join
deduplication

How to select id with max date group by category in PostgreSQL?

sql
prompt-engineering
best-practices
performance

What is the equivalent of 'describe table' in SQL Server?

sql
database-documentation
metadata-visibility
sql-scripts

Command for adding a default constraint

sql
database-design
data-consistency
sql-best-practices

Mysql select rows where left join is null

sql
join
left-join
subqueries

Insert Picture into SQL Server 2005 Image Field using only SQL

sql
bulk-admin
image-insertion
sql-performance

How to return an incremental group number per group in SQL

sql
window-functions
dense-rank
sql-performance

Do SQL connections opened with PDO in PHP have to be closed

sql
best-practices
garbage-collection
resource-management

Split column into multiple rows in Postgres

sql
prompt-engineering
join
performance

Count(*) vs count(column-name) - which is more correct?

sql
performance
best-practices
query-optimization

How to drop all NOT NULL constraints from a PostgreSQL table in one go

sql
database-administration
postgresql
constraint-removal

How to release possible Postgres row locks?

sql
lock-handling
database-optimization
transaction-isolation

Sql Server - In clause with a declared variable

sql
sql-injection
dynamic-sql
join-operations

How do NULL values affect performance in a database search?

sql
database-performance
data-integrity
query-optimization

Postgresql IF statement

sql
conditional-logic
database-performance
error-handling

Exists vs JOIN and use of EXISTS clause

sql
exists-clause
join-operations
sql-performance
explain.codes / Sql