Explain Codes LogoExplain Codes Logo

Sql

How can I get all sequences in an Oracle database?

sql
database-management
sql-queries
performance-optimization

Ms SQL Exception: Incorrect syntax near '@P0'

sql
sql-server
hibernate-configuration
sql-syntax

Left Outer Join using + sign in Oracle 11g

sql
join
sql-syntax
best-practices

Getting list of tables, and fields in each, in a database

sql
metadata
database-queries
sql-server

Can I Create a One-Time-Use Function in a Script or Stored Procedure?

sql
dynamic-sql
stored-procedures
temp-tables

Inserting rows into a table with one IDENTITY column only

sql
identity-columns
database-design
transaction-safety

Sql query with NOT LIKE IN

sql
prompt-engineering
best-practices
join

How do I grant myself admin access to a local SQL Server instance?

sql
sqlcmd
single-user-mode
sysadmin-role

What is the best way to implement soft deletion?

sql
soft-deletion
database-views
partitioning

Mysql - SELECT all columns WHERE one column is DISTINCT

sql
distinct
group-by
subqueries

Equivalent of explode() to work with strings in MySQL

sql
prompt-engineering
functions
best-practices

Postgresql "Column does not exist" but it actually does

sql
best-practices
sql-syntax
database-structure

If EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT

sql
transaction-control
database-management
sql-server

How to drop multiple tables in PostgreSQL using a wildcard

sql
database-management
postgresql
best-practices

Howto? Parameters and LIKE statement SQL

sql
sql-injection
stored-procedures
performance-tuning

How to rollback or commit a transaction in SQL Server

sql
transaction-handling
error-handling
database-optimization

How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?

sql
file-system-permissions
mysql-errorcode-13
apparmor

How to speed up insertion performance in PostgreSQL

sql
performance
best-practices
optimization

Transactsql to run another TransactSQL script

sql
sqlcmd-mode
dynamic-execution
script-automation

Not all parameters were used in the SQL statement (Python, MySQL)

sql
parameterized-queries
sql-injection
database-connection