Explain Codes LogoExplain Codes Logo

Sql

How to insert multiple records and get the identity value?

sql
bulk-insertion
identity-values
cursor-free

Sql Server - copy stored procedures from one db to another

sql
sql-server
stored-procedures
database-migration

Select count of rows in another table in a Postgres SELECT statement

sql
join
performance
best-practices

Get Multiple Values in SQL Server Cursor

sql
error-handling
cursor-operations
set-based-operations

Sql SELECT everything after a certain character

sql
substring-extraction
sql-functions
database-ecosystems

Computed / calculated / virtual / derived / generated columns in PostgreSQL

sql
expression-indexes
computed-columns
postgresql

Postgresql create table if not exists

sql
database-management
postgresql
sql-queries

Creating a random number using MySQL

sql
random-number-generation
mysql-functions
database-performance

Column name or number of supplied values does not match table definition

sql
best-practices
data-migration
sql-server-syntax

How to count the number of occurrences of a character in an Oracle varchar value?

sql
prompt-engineering
best-practices
regex

Date in mmm yyyy format in PostgreSQL

sql
date-formatting
postgresql
to_char

Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)

sql
transaction-management
mysql
database-operations

Error when connect database continuously

sql
retry-policies
database-connections
error-handling

Is it possible to output a SELECT statement from a PL/SQL block?

sql
prompt-engineering
best-practices
pipelined-functions

Recommended SQL database design for tags or tagging

sql
database-design
performance-optimization
indexing

Sql query to select distinct row with minimum value

sql
window-functions
sql-queries
performance-optimization

Database/sql Tx - detecting Commit or Rollback

sql
transaction-management
error-handling
database-operations

When running UPDATE ... datetime = NOW(); will all rows updated have the same date/time?

sql
timestamp
database-management
performance-optimization

Synchronizing client-server databases

sql
conflict-resolution
data-synchronization
database-design

How do I write LINQ's .Skip(1000).Take(100) in pure SQL?

sql
pagination
performance-optimization
sql-queries
explain.codes / Sql