Explain Codes LogoExplain Codes Logo

Sql

Mysql, better to insert NULL or empty string?

sql
null
empty-string
data-integrity

Select statement to find duplicates on certain fields

sql
duplicates
subqueries
window-functions

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

sql
constraint-violation
data-integrity
debugging

How to combine date from one field with time from another field - MS SQL Server

sql
datetime
performance
readability

Right query to get the current number of connections in a PostgreSQL DB

sql
postgresql
database
connections

Cte error: "Types don't match between the anchor and the recursive part"

sql
data-types
casting
null-handling

How can I group by datetime column without considering time

sql
grouping
datetime
performance

Sql order string as number

sql
string-sorting
performance
cte

What is the best tool to compare two SQL Server databases (schema and data)?

sql
database-comparison
tools
synchronization

Converting Select results into Insert script - SQL Server

sql
insert-scripts
dynamic-sql
stored-procedures

Error Code: 2013. Lost connection to MySQL server during query

sql
mysql
performance
timeout

Postgres manually alter sequence

sql
sequences
setval
database-performance

New Line Issue when copying data from SQL Server 2012 to Excel

sql
new-line
excel
ssms

How do I query between two dates using MySQL?

sql
date-queries
date-format
string-to-date

Can I concatenate multiple MySQL rows into one field?

sql
group-concat
distinct
data-aggregation

Mysql DELETE FROM with subquery as condition

sql
delete
subquery
temporary-table

Remove the last character in a string in T-SQL?

sql
string-manipulation
null-handling
best-practices

How can I tell what edition of SQL Server runs on the machine?

sql
editionid
compatibility
database-management

How to view the SQL queries issued by JPA?

sql
jpa-logging
hibernate
eclipselink

Change Schema Name Of Table In SQL

sql
schema-transfer
dynamic-sql
error-handling