Explain Codes LogoExplain Codes Logo

Sql

How can I tell when a MySQL table was last updated?

sql
database-management
mysql-optimization
timestamping

With (NOLOCK) vs SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

sql
data-integrity
performance-optimization
database-isolation-levels

Sql Server: Arithmetic overflow error converting expression to data type int

sql
overflow-error
data-type
sql-server

When can I save JSON or XML data in an SQL Table

sql
json-optimization
performance-tuning
database-design

How to use LIKE with column name

sql
pattern-matching
sql-server
mysql

Determine Oracle null == null

sql
null-handling
performance-optimization
database-queries

How do I generate a SQL script from my diagram in MySQL Workbench?

sql
sql-scripting
mysql-workbench
database-design

In SQL Server, when should you use GO and when should you use semi-colon ;?

sql
sql-best-practices
sql-syntax
sql-performance

Strings as Primary Keys in MySQL Database

sql
database-design
performance-optimization
data-integrity

Why does MySQL report a syntax error on FULL OUTER JOIN?

sql
join
union
left-join

Convert integer to text in SQLite's SELECT query?

sql
data-extraction
dynamic-queries
type-consistency

Check if a parameter is null or empty in a stored procedure

sql
sql-hacks
best-practices
flow-control

Mysql Workbench: How to keep the connection alive

sql
mysql-workbench
ssh-tunnel
connection-timeout

Coalesce Function in TSQL

sql
null-handling
sql-queries
ansi-sql-standard

How to group by month using SQL Server?

sql
prompt-engineering
join
modules

Can we use join for two different database tables?

sql
cross-database-joins
sql-server
database-design

Mysql unknown column in ON clause

sql
join
best-practices
sql-wizardry

Executing a stored procedure inside BEGIN/END TRANSACTION

sql
transactional-database
stored-procedures
error-handling

Convert Datetime column from UTC to local time in select statement

sql
datetime
sql-server
timezone

Finding similar strings with PostgreSQL quickly

sql
join
performance-boosting
index-maintenance
explain.codes / Sql