Explain Codes LogoExplain Codes Logo

Sql

In a join, how to prefix all column names with the table they came from

sql
dynamic-sql
column-aliases
sql-injections

Language SQL vs LANGUAGE plpgsql in PostgreSQL functions

sql
database-optimization
function-design
sql-performance

Sql Update from One Table to Another Based on ID Match

sql
update
join
merge

Remove uniqueness of index in PostgreSQL

sql
database-management
postgresql
index-management

How do I find records that are not joined?

sql
join
best-practices
performance

Boolean 'NOT' in T-SQL not working on 'bit' datatype?

sql
bitwise-negation
sql-queries
performance-tips

Postgres Case Sensitivity

sql
best-practices
database-migration
case-sensitivity

Including parameters in OPENQUERY

sql
sql-injection
dynamic-sql
sp_executesql

How to insert into a table with just one IDENTITY column?

sql
identity-insert
default-values
sql-server

In SQL / MySQL, what is the difference between "ON" and "WHERE" in a join statement?

sql
join
performance
best-practices

Sql JOIN vs IN performance?

sql
join-performance
sql-server
query-optimization

Best way to get result count before LIMIT was applied

sql
performance
optimization
count-operations

Insert the same fixed value into multiple rows

sql
database-management
sql-queries
data-insertion

Mysql Multiple Joins in one query?

sql
join
performance
best-practices

List names of all tables in a SQL Server 2012 schema

sql
metadata
database-optimizations
sql-queries

Increasing the Command Timeout for SQL command

sql
sql-performance
query-optimization
paging

How to execute .sql file using powershell?

sql
sql-server
powershell
sqlcmd

Select a column if other column is NULL

sql
null-handling
sql-functions
conditional-statements

How to create a temporary function in PostgreSQL?

sql
prepared-statements
performance
best-practices

Is it possible to have a default parameter for a mysql stored procedure?

sql
stored-procedures
default-parameters
mysql
explain.codes / Sql