Explain Codes LogoExplain Codes Logo

Sql

Sql Group By with an Order By

sql
group-by
order-by
sql-best-practices

How to turn IDENTITY_INSERT on and off using SQL Server 2008?

sql
sql-server
identity-insert
bulk-insert

Unable to drop and create database in SQL Server

sql
database-management
sql-server
best-practices

Changing the size of a column referenced by a schema-bound view in SQL Server

sql
data-migration
schema-binding
database-design

Can't drop table: A foreign key constraint fails

sql
foreign-key-constraints
database-management
data-integrity

Two single-column indexes vs one two-column index in MySQL?

sql
indexing
performance
database-optimization

How to declare a variable in MySQL?

sql
database-management
sql-variables
mysql-queries

Entering keys manually with Entity Framework

sql
entity-framework
database-integrity
transactions

What is "Connect Timeout" in SQL Server connection string?

sql
connection-string
timeout-settings
sql-server-configuration

Remove Primary Key in MySQL

sql
database-schema
sql-queries
data-backup

How to select date without time in SQL

sql
date-truncation
sql-performance
best-practices

Count the number of occurrences of a string in a VARCHAR field?

sql
sql-functions
performance-optimization
database-management

How can I use SUM for bit columns?

sql
bit-manipulation
aggregate-functions
t-sql

How can I search (case-insensitive) in a column using LIKE wildcard?

sql
case-insensitive-search
sql-functions
database-performance

Entity Framework. Delete all rows in table

sql
entity-framework
database-management
data-deletion

Sql UPDATE all values in a field with appended string CONCAT not working

sql
null-values
concat-function
mysql-quirks

Sql - Select First 10 Rows Only?

sql
limit
offset
fetch-first

Mysql "Group By" and "Order By"

sql
join
subqueries
indexing

How to change a PG column to NULLABLE TRUE?

sql
database-design
performance-implications
postgresql

Use multiple conflict_target in ON CONFLICT clause

sql
prompt-engineering
best-practices
conflict-resolution