Explain Codes LogoExplain Codes Logo

Sql

Display names of all constraints for a table in Oracle SQL

sql
database-administration
sql-queries
constraint-management

Is there a Max function in SQL Server that takes two values like Math.Max in .NET?

sql
max-function
sql-server
math-max

Write a number with two decimal places SQL Server

sql
decimal
format-function
sql-performance

Join two SELECT statement results

sql
join
sql-queries
database-operations

Select from table by knowing only date without time (ORACLE)

sql
performance
indexes
best-practices

How do I escape a single quote in SQL Server?

sql
sql-escape
sql-queries
sql-best-practices

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