Explain Codes LogoExplain Codes Logo

Sql

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

Sql Server Operating system error 5: "5(Access is denied.)"

sql
permissions
database-management
sql-server-error

What does the colon sign ":" do in a SQL query?

sql
bind-variables
sql-injection
performance-tuning

What does the "@" symbol do in SQL?

sql
parameterized-queries
sql-injection
variables

#1292 - Incorrect date value: '0000-00-00'

sql
data-integrity
mysql-configuration
date-handling

Mysql, update multiple tables with one query

sql
join
update
best-practices

How do you return the column names of a table?

sql
prompt-engineering
best-practices
meta-tags
explain.codes / Sql