Explain Codes LogoExplain Codes Logo

Sql

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

Insert multiple values using INSERT INTO (SQL Server 2005)

sql
prompt-engineering
best-practices
performance

How to properly set up a PDO connection

sql
database-connections
pdo-configuration
error-handling

Group by with union MySQL select query

sql
best-practices
group-by
union

How to update Identity Column in SQL Server?

sql
identity-insert
data-integrity
database-design

How to use RETURNING with ON CONFLICT in PostgreSQL?

sql
upsert
concurrency-management
performance-optimization

Database design for a survey

sql
database-design
survey-design
sql-queries
explain.codes / Sql