Explain Codes LogoExplain Codes Logo

Sql

Cannot connect to (LocalDB)\MSSQLLocalDB -> Login failed for user 'User-PC\User'

sql
sql-server
localdb
connection-issues

Can I use VARCHAR as the PRIMARY KEY?

sql
data-integrity
primary-key
varchar

Filter by COUNT(*)?

sql
best-practices
group-by
having-clause

Unwrap postgresql array into rows

sql
performance
best-practices
data-type-mismatches

Grouping into interval of 5 minutes within a time range

sql
interval
performance
postgresql

How to find the size of a table in SQL?

sql
database-performance
sql-server
database-optimization

How to add plus one (+1) to a SQL Server column in a SQL Query

sql
sql-injection
bulk-updates
concurrent-updates

Sql Join Table Naming Convention

sql
best-practices
data-integrity
database-design

T-sql Cast versus Convert

sql
data-type-conversion
sql-server
best-practices

Find stored procedure by name

sql
database-search
sql-server-management-studio
stored-procedures

How do I remove the first characters of a specific column in a table?

sql
sql-best-practices
string-manipulation
database-performance

Error 1452: Cannot add or update a child row: a foreign key constraint fails

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

Postgresql: Remove attribute from JSON column

sql
json-manipulation
postgresql-features
database-performance

Replace Into Query Syntax

sql
best-practices
performance
data-integrity

Tinyint vs Bit?

sql
database-design
data-types
sql-server

Is there a way to list open transactions on SQL Server 2000 database?

sql
dbcc
transactions
sql-server-2000

Sql Query To Obtain Values That Occur More Than Once

sql
sql-query
group-by
count

Convert integer to hex and hex to integer

sql
convert-function
hex-string
sql-server

Solutions for INSERT OR UPDATE on SQL Server

sql
transactional-updates
concurrency-control
upsert-pattern

Paging with Oracle

sql
pagination
oracle
sql-optimization
explain.codes / Sql