Explain Codes LogoExplain Codes Logo

Sql

How do I select a 1 as a bit in a sql-server view?

sql
prompt-engineering
best-practices
performance

Mysql: ERROR 1215 (HY000): Cannot add foreign key constraint

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

Postgresql GROUP BY different from MySQL?

sql
group-by
postgresql
mysql-comparison

Entity Framework error: Cannot insert explicit value for identity column in table

sql
entity-framework
database-design
best-practices

Sql Query If Parameter Is Null Select All

sql
null-handling
database-performance
sql-optimization

Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

sql
sql-server
connection-protocol
authentication

Column calculated from another column?

sql
best-practices
performance
join

Sql Server equivalent to Oracle's NULLS FIRST?

sql
best-practices
data-manipulation
sql-server

Does it make sense to use an index that will have a low cardinality?

sql
index-usage
performance-benefits
database-optimization

How to Select a Substring in Oracle SQL up to a Specific Character?

sql
prompt-engineering
join
best-practices

Should every SQL Server foreign key have a matching index?

sql
indexing
performance-optimization
database-management

Sql script to find invalid email addresses

sql
email-validation
sql-scripts
data-cleansing

Return rows in random order

sql
randomization
database-performance
data-analysis

Sql Server - where is "sys.functions"?

sql
best-practices
performance
functions

Mysql Select Records for Duplicates Using Multiple Columns

sql
prompt-engineering
join
performance

Mysql order by "best match"

sql
prompt-engineering
best-practices
performance

What is the difference between a primary key and a unique constraint?

sql
data-integrity
database-design
performance-tuning

Why does Sql Server keep executing after raiserror when xact_abort is on?

sql
best-practices
error-handling
transaction-management

See whether an item appears more than once in a database column

sql
duplicates
sql-queries
database-management

Can I protect against SQL injection by escaping single-quote and surrounding user input with single-quotes?

sql
input-validation
sql-injection
stored-procedures
explain.codes / Sql