Explain Codes LogoExplain Codes Logo

Sql

Move SQL data from one table to another

sql
data-transfers
sql-server
mysql

Delete duplicate rows from small table

sql
delete-duplicates
postgresql
data-management

Creating table names that are reserved words/keywords in MS SQL Server

sql
best-practices
database-design
sql-server

Remove trailing zeros from decimal in SQL Server

sql
data-integrity
decimal-precision
sql-conversions

Sql to find the number of distinct values in a column

sql
distinct-count
sql-queries
database-performance

Generate random int value from 3 to 6

sql
random-number-generation
sql-server
database-performance

How to round an average to 2 decimal places in PostgreSQL?

sql
prompt-engineering
best-practices
dataframe

Sql Server Case Statement when IS NULL

sql
case-statement
sql-server
data-type-consistency

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

sql
collation
mysql-error
database-migration

How can I find out what FOREIGN KEY constraint references a table in SQL Server?

sql
foreign-key
sql-server
database-management

Alternatives to REPLACE on a text or ntext datatype

sql
data-manipulation
sql-server
performance-tuning

Delete duplicate records from a SQL table without a primary key

sql
data-integrity
database-restrictions
duplicate-records

How do I drop a foreign key constraint only if it exists in sql server?

sql
foreign-key
sql-server
t-sql

I want to copy table content from one database and insert it into another database table

sql
data-transfer
database-migration
sql-commands

How to select data of a table from another database in SQL Server?

sql
cross-server-query
linked-servers
sql-server

How to insert data to MySQL with auto-incremented column(field)?

sql
auto-increment
mysql
insertion

T-sql Conditional Order By

sql
sql-injection
dynamic-sql
conditional-ordering

Mysql Error: 'Access denied for user 'root'@'localhost'

sql
mysql-error
database-authentication
sql-commands

How to check the maximum number of allowed connections to an Oracle database?

sql
database-management
connection-limits
oracle-database

Identity increment is jumping in SQL Server database

sql
identity-cache
trace-flags
database-configuration
explain.codes / Sql