Explain Codes LogoExplain Codes Logo

Sql

Combining "LIKE" and "IN" in SQL Server

sql
full-text-search
subqueries
table-value-constructors

Sql Server LIKE containing bracket characters

sql
pattern-matching
sql-performance
database-optimization

Sql Server SELECT LAST N Rows

sql
performance
best-practices
join

Sql: How to properly check if a record exists

sql
best-practices
performance
join

Search text in stored procedure in SQL Server

sql
search-engineering
sql-queries
database-management

Sql update statement in C#

sql
sql-injection
database-connection
async-api

How to select records from last 24 hours using SQL?

sql
database-optimization
sql-queries
date-and-time

How to execute a .sql script on Heroku?

sql
database-seeding
heroku-cli
rake-task

How can I append a string to an existing field in MySQL?

sql
join
best-practices
dataframe

Update query using Subquery in Sql Server

sql
subqueries
update-queries
sql-performance

How to get next/previous record in MySQL?

sql
performance
best-practices
join

Sql Inner-join with 3 tables?

sql
join
query-optimization
best-practices

Insert data in 3 tables at a time using Postgres

sql
transactional-integrity
concurrent-writes
temporary-tables

How to concatenate columns in a PostgreSQL SELECT?

sql
join
best-practices
performance

Drop all databases from server

sql
database-management
sql-server
database-deletion

How to document a database

sql
database-documentation
version-control
business-rules

Export schema without data

sql
database-structure
export-schema
mysql

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

sql
database-disconnection
sql-server
transactional-integrity

Sql Server 2008: TOP 10 and distinct together

sql
distinct
subqueries
optimizations

How to insert multiple rows in SQLite?

sql
bulk-operations
performance-optimization
sql-queries
explain.codes / Sql