Explain Codes LogoExplain Codes Logo

Sql

Sql Server Operating system error 5: "5(Access is denied.)"

sql
permissions
database-management
sql-server-error

What does the colon sign ":" do in a SQL query?

sql
bind-variables
sql-injection
performance-tuning

What does the "@" symbol do in SQL?

sql
parameterized-queries
sql-injection
variables

#1292 - Incorrect date value: '0000-00-00'

sql
data-integrity
mysql-configuration
date-handling

Mysql, update multiple tables with one query

sql
join
update
best-practices

How do you return the column names of a table?

sql
prompt-engineering
best-practices
meta-tags

How to group by month from Date field using SQL

sql
date-formatting
sql-server
group-by

Sql get the last date time record

sql
best-practices
performance
functions

Dataset Panel (Report Data) in SSRS Designer is Gone

sql
reporting-services
data-set
sql-server

How to use SQL LIKE condition with multiple values in PostgreSQL?

sql
regex
pattern-matching
sql-queries

Convert SQL Server result set into string

sql
string-concatenation
sql-server
data-types

Cannot simply use PostgreSQL table name ("relation does not exist")

sql
database-connection
postgresql-queries
sql-syntax

Sql recursive query that gets all ancestors of an item

sql
recursive-ctes
sql-queries
database-performance

Group BY and COUNT using ActiveRecord

sql
prompt-engineering
best-practices
join

Use cases for NoSQL

sql
database-design
data-modeling
nosql-databases

No unique or exclusion constraint matching the ON CONFLICT

sql
unique-constraints
database-design
conflict-resolution

Re-order columns of table in Oracle

sql
database-performance
sql-optimization
oracle-database

Auto Increment after delete in MySQL

sql
referential-integrity
database-design
sql-operations

Multiple FULL OUTER JOIN on multiple tables

sql
join
best-practices
data-consistency

Sql Server 2008: The columns in table do not match an existing primary key or unique constraint

sql
foreign-key
primary-key
database-schema
explain.codes / Sql