Explain Codes LogoExplain Codes Logo

Sql

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

Counting null and non-null values in a single query

sql
performance
best-practices
sql-queries

What is the best way to convert an int or null to boolean value in an SQL query?

sql
conditional-constructs
boolean-conversion
sql-queries

Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column

sql
data-types
csv-import
sql-server

Create a SQL query to retrieve most recent records

sql
sql-queries
performance-optimization
database-optimization

Can't see MySQL BIT field value when using SELECT

sql
mysql
select
bit-field

Postgresql: Case insensitive string comparison

sql
database-indexing
postgresql-extensions
case-insensitive-comparison

Postgresql Index on JSON

sql
indexing
json
performance

Primary key or Unique index?

sql
primary-key
database-design
data-integrity

Export a CREATE script for a database

sql
backup
database-management
pgadmin

Delete many rows from a table using id in Mysql

sql
bulk-operations
database-performance
sql-optimization

Syntax for INSERTing into a table with no values?

sql
default-values
database-design
data-integrity

T-sql STOP or ABORT command in SQL Server

sql
error-handling
script-execution
sql-server

What is ROWS UNBOUNDED PRECEDING used for in Teradata?

sql
window-functions
teradata
sql-clauses

How to use BOOLEAN type in SELECT statement

sql
boolean
sql-queries
database-queries
explain.codes / Sql