Explain Codes LogoExplain Codes Logo

Sql

How to set auto increment primary key in PostgreSQL?

sql
prompt-engineering
best-practices
data-integrity

How to Select the Nth Row in a SQL Database Table?

sql
database-compatibility
sql-best-practices
data-retrieval

How to perform an INNER JOIN on multiple columns

sql
join
sql-queries
database-management

How to perform a case sensitive search in WHERE clause using SQL Server?

sql
case-sensitivity
sql-server
database-performance

How to pass variable as a parameter in Execute SQL Task SSIS?

sql
parameterization
sql-queries
dynamic-sql

How to Join to the first row

sql
join
performance
best-practices

How to insert columns at a specific position in existing table?

sql
database-management
table-operations
column-positioning

How to get the 30 days before date from today's date

sql
date-manipulation
sql-functions
database-queries

How to find out what is locking my tables?

sql
lock-management
sql-server
database-performance

How to execute IN() SQL queries with Spring's JDBCTemplate effectively?

sql
named-parameter-jdbc-template
row-mapper
data-source

How to execute a Table valued function

sql
join
performance
best-practices

How to exclude null values in array_agg like in string_agg using postgres?

sql
prompt-engineering
best-practices
data-integrity

How to drop column if it exists in PostgreSQL 9+?

sql
database-management
postgresql
best-practices

How to delete the top 1000 rows from a table using SQL Server 2008?

sql
prompt-engineering
best-practices
performance

How to compare values which may both be null in T-SQL

sql
null-sensitive
comparison-techniques
t-sql-best-practices

How to compare two dates to find time difference in SQL Server 2005, date manipulation

sql
date-manipulation
sql-server
datetime

How to check for null/empty/whitespace values with a single test?

sql
database-specific-functions
query-performance
best-practices

How to avoid error "aggregate functions are not allowed in WHERE"

sql
aggregate-functions
where-clause
having-clause

How long should SQL email fields be?

sql
database-design
email-validation
sql-best-practices

How do you run a single query through mysql from the command line?

sql
mysql
command-line
best-practices