Explain Codes LogoExplain Codes Logo

Sql

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

Should I use != or <> for not equal in T-SQL?

sql
best-practices
sql-standards
database-migration

Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

sql
identity-insert
database-management
sql-best-practices

Select data from "show tables" MySQL query

sql
information-schema
mysql-queries
database-management

Generate Dates between date ranges

sql
prompt-engineering
performance
best-practices

Alter a SQL server function to accept new optional parameter

sql
default-values
function-logic
sql-server-functions

How to Query Database by ID Using SqlAlchemy?

sql
prompt-engineering
best-practices
performance
explain.codes / Sql