Explain Codes LogoExplain Codes Logo

Sql

Should I use != or <> for not equal in T-SQL?

sql
best-practices
sql-standards
database-migration

Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

sql
identity-insert
database-management
sql-best-practices

Select data from "show tables" MySQL query

sql
information-schema
mysql-queries
database-management

Generate Dates between date ranges

sql
prompt-engineering
performance
best-practices

Alter a SQL server function to accept new optional parameter

sql
default-values
function-logic
sql-server-functions

How to Query Database by ID Using SqlAlchemy?

sql
prompt-engineering
best-practices
performance

Mysql dump by query

sql
backup
database
mysqldump

What is the best way to paginate results in SQL Server

sql
pagination
sql-server
performance-optimization

Replace Default Null Values Returned From Left Outer Join

sql
default-values
left-outer-join
coalesce

How do you manually execute SQL commands in Ruby On Rails using NuoDB

sql
sql-execution
rails-activerecord
database-connections

How to use a LIKE with a JOIN in SQL?

sql
join
performance
best-practices

Update records in table from CTE

sql
cte
sql-update
join

Sql query to find record with ID not in another table

sql
join
performance
best-practices

Mysql's now() +1 day

sql
date-arithmetic
mysql-functions
sql-best-practices

Fastest check if row exists in PostgreSQL

sql
indexing
transaction-control
performance-optimization

How do I obtain raw SQL from a query builder?

sql
logging
debugging
performance

Add a summary row with totals

sql
prompt-engineering
best-practices
grouping-sets

Mysql pivot row into dynamic number of columns

sql
dynamic-pivot
sql-injection
prepared-statements

Questions every good Database/SQL developer should be able to answer

sql
join
data-types
indexing

Store select query's output in one array in postgres

sql
array-constructor
query-results
database-optimization
explain.codes / Sql