Explain Codes LogoExplain Codes Logo

Sql

Could not find an implementation of the query pattern

sql
linq
query-pattern
database-context

How to Concatenate Text from Multiple Rows into a Single Text String in SQL Server

sql
prompt-engineering
join
performance

Oracle date "Between" Query

sql
date-formatting
sql-queries
performance-optimization

Get day of the week in SQL Server 2005/2008

sql
datefirst
datepart
sql-server

Postgresql: FOREIGN KEY/ON DELETE CASCADE

sql
foreign-key
database-design
performance-optimization

How to use (install) dblink in PostgreSQL?

sql
dblink
postgresql
database-connections

Is there any way to show progress on a `gunzip < database.sql.gz | mysql ...` process?

sql
prompt-engineering
performance
data-integrity

How to connect an existing SQL Server login to an existing SQL Server database user of same name

sql
sql-server
database-users
login-credentials

Case statement in MySQL

sql
case-statement
mysql-functions
sql-queries

Turn off constraints temporarily (MS SQL)

sql
data-integrity
constraint-management
sql-server

Parameterize an SQL IN clause

sql
sql-injection
parameterization
sql-server

Difference between JOIN and INNER JOIN

sql
join
best-practices
performance

Sql query to return differences between two tables

sql
data-integrity
sql-techniques
data-comparison

Mysql - Replace Character in Columns

sql
database-management
data-cleaning
sql-functions

How do I select an entire row which has the largest ID in the table?

sql
sub-select
analytical-functions
sql-performance

Drop a temporary table if it exists

sql
best-practices
data-manipulation
database-operations

Sql Case Sensitive String Compare

sql
case-sensitive-string-comparisons
sql-collations
data-integrity

Oracle SQL Developer - tables cannot be seen

sql
database-visibility
sql-developer
upgrade-issues

Order varchar string as numeric

sql
data-conversion
sql-indexing
database-performance

Mysql GROUP_CONCAT duplicates

sql
distinct
group_concat
performance-implications
explain.codes / Sql