Explain Codes LogoExplain Codes Logo

Sql

How can I work with SQL NULL values and JSON in a good way?

sql
json-marshalling
custom-types
null-values

Is there any difference between GROUP BY and DISTINCT

sql
distinct-vs-group-by
sql-engine
performance-optimization

Perform insert for each row taken from a select?

sql
set-based-operations
cursor-based-methods
sql-injection

Sql Query for Logins

sql
sql-injection
query-optimization
index-usage

Cannot Resolve Collation Conflict

sql
collation-conflict
sql-server
database-management

Concatenate string with field value in MySQL

sql
join
concat
performance

Sql - Query to get server's IP address

sql
sql-server
stored-procedures
network-configuration

Datetime in where clause

sql
datetime
sql-server
performance

Case in SELECT Statement

sql
prompt-engineering
best-practices
conditional-statements

Capturing count from an SQL query

sql
sql-injection
stored-procedures
sql-queries

How do you insert null values into SQL Server

sql
null-values
sql-server
database-management

How to do a batch insert in MySQL

sql
batch-insert
mysql-performance
data-insertion

In SQL, is UPDATE always faster than DELETE+INSERT?

sql
update-vs-delete-insert
database-performance
sql-optimization

Postgresql: Drop a function without parameters

sql
database-management
function-overloading
postgresql

Functions vs Stored Procedures

sql
best-practices
performance
sql-injection

How to check if a table exists in a given schema

sql
prompt-engineering
information-schema
system-catalogs

Postgresql query to rename and change column type with single query

sql
database-manipulation
data-types
sql-queries

Get the last inserted row ID (with SQL statement)

sql
output-clause
scope-identity
sql-server

Can I loop through a table variable in T-SQL?

sql
set-based-solutions
sql-performance
sql-best-practices

Unknown Column In Where Clause

sql
subqueries
common-table-expressions
sql-syntax
explain.codes / Sql