Explain Codes LogoExplain Codes Logo

Sql

How do you update a DateTime field in T-SQL?

sql
best-practices
datetime
sql-server

How can you get the active users connected to a PostgreSQL database via SQL?

sql
database-activity
postgresql
sql-queries

Mysql INSERT INTO table VALUES.. vs INSERT INTO table SET

sql
insert-optimizations
sql-injections
bulk-insert

Sql: How do I use a parameter for TOP like in SELECT TOP @amount?

sql
sql-server-standards
query-optimization
performance-tuning

Sql Server ':setvar' Error

sql
sqlcmd-mode
sql-server-error
variable-setting

Returning Month Name in SQL Server Query

sql
date-format
sql-server
date-manipulation

Boolean Expressions in SQL Select list

sql
best-practices
functions
join

Using GROUP_CONCAT on subquery in MySQL

sql
subquery
group_concat
sql-queries

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
explain.codes / Sql