Explain Codes LogoExplain Codes Logo

Sql

Mysql syntax for Join Update

sql
join
transactions
best-practices

What is the meaning of the prefix N in T-SQL statements and when should I use it?

sql
unicode-data
t-sql-best-practices
data-safeguard

Sql WHERE condition is not equal to?

sql
best-practices
performance
join

Datetime group by date and hour

sql
datetime
grouping
database

Adding named foreign key constraints in a SQL Create statement

sql
data-integrity
schema-evolution
foreign-key-constraints

Select info from table where row has max date

sql
window-functions
sql-performance
best-practices

How to order by with union in SQL?

sql
join
best-practices
union

'like ('%this%' OR '%that%') and something=else' not working

sql
pattern-matching
sql-queries
best-practices

Show the current username in MySQL?

sql
database-connection
mysql-queries
security-best-practices

Sql Return only duplicate rows

sql
subquery
join
window-functions

Unpivot with column name

sql
sql-fiddle
pivot-tables
performance-optimization

When or why would you use a right outer join instead of left?

sql
join
data-integrity
sql-performance

How to find duplicate records in PostgreSQL

sql
prompt-engineering
best-practices
join

Sql Server, division returns zero

sql
decimal-data-types
division-by-zero
sql-server-performance

Sql Server - Return value after INSERT

sql
best-practices
sql-server
output-clause

T-sql split string

sql
string-split
sql-server
delimiter

Tsql - How to use GO inside of a BEGIN .. END block?

sql
dynamic-sql
try-catch
sql-execution

How to SELECT WHERE NOT EXIST using LINQ?

sql
linq-transformation
sql-linq
entity-framework

How to select all records from one table that do not exist in another table?

sql
join
performance
best-practices

How do I create a foreign key in SQL Server?

sql
foreign-key
database-design
referential-integrity
explain.codes / Sql