Explain Codes LogoExplain Codes Logo

Sql

How can I check if an SQL result contains a newline character?

sql
data-cleansing
data-validation
sql-queries

Get top 1 row of each group

sql
database-design
performance-optimization
sql-queries

Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction

sql
lock-wait-timeout
database-performance
transaction-management

Get timestamp of one month ago in PostgreSQL

sql
data-archiving
cron-jobs
sql-performance

Get Entity Framework 6 use NOLOCK in its underneath SELECT statements

sql
database-performance
entity-framework
sql-hints

Get count of records affected by INSERT or UPDATE in PostgreSQL

sql
transaction-management
jdbc-management
performance-optimization

Exporting data in SQL Server as INSERT INTO

sql
scripting
database-administration
sql-server

Error: permission denied for sequence cities_id_seq using Postgres

sql
database-permissions
postgres-privileges
sql-best-practices

Drop multiple tables in one shot in MySQL

sql
foreign-key-checks
dynamic-sql
database-automation

Does UNION ALL guarantee the order of the result set

sql
best-practices
join
order-by

Does the order of columns matter in a group by clause?

sql
group-by
indexing
database-optimization

Does sqlite support any kind of IF(condition) statement in a select

sql
conditional-statements
sql-functions
best-practices

Difference between filter and filter_by in SQLAlchemy

sql
orm
query-optimization
best-practices

Determine What User Created Objects in SQL Server

sql
sql-server
database-audit
metadata

Declare variable in SQLite and use it

sql
transaction-safety
variable-declaration
sqlite-optimization

Database Structure for Tree Data Structure

sql
database-design
tree-data-structure
performance-optimization

Create a date from day month and year with T-SQL

sql
date-calculation
t-sql
sql-server

Count cumulative total in PostgreSQL

sql
window-functions
postgresql
data-visualization

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

sql
database-management
asp-net
sql-server

Copy tables from one database to another in SQL Server

sql
data-transfer
sql-server
database-management
explain.codes / Sql