Explain Codes LogoExplain Codes Logo

Sql

Convert varchar into datetime in SQL Server

sql
date-format
sql-server
string-manipulation

Com.mysql.jdbc.exceptions.jdbc4.communicationsexception: Communications link failure

sql
database-connection
jdbc-exception
mysql-connector

Combining Date and Time Fields to DateTime, SQL Server 2008

sql
date-time
sql-server
data-types

Checking multiple columns for one value

sql
subqueries
performance
best-practices

Check if field exists in CosmosDB JSON with SQL - nodeJS

sql
database-performance
cosmosdb
sql-queries

Changing the maximum length of a varchar column?

sql
database-management
sql-optimization
data-types

Changing the CommandTimeout in SQL Management studio

sql
commandtimeout
sql-management-studio
query-execution

Case WHEN statement for ORDER BY clause

sql
prompt-engineering
best-practices
performance

Cannot use UPDATE with OUTPUT clause when a trigger is on the table

sql
transaction
stored-procedures
concurrency-control

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed

sql
full-text-search
performance-requirements
indexing

Can I do a max(count(*)) in SQL?

sql
window-functions
sql-performance
sql-optimization

Calculating time difference between 2 dates in minutes

sql
timestampdiff
date-manipulation
mysql-functions

Best way to do multi-row insert in Oracle?

sql
database-optimization
performance-tuning
oracle-database

Best database field type for a URL

sql
database-design
performance-optimization
sql-injection

Are Databases and Functional Programming at odds?

sql
data-integrity
functional-programming
database-performance

Alter table - adding AUTOINCREMENT in MySQL

sql
autoincrement
mysql
database-management

Alter multiple columns in a single statement

sql
best-practices
data-loss
performance

Adding a column after another column within SQL

sql
data-types
alter-table
database-management

Add a temporary column with a value

sql
prompt-engineering
best-practices
join

1052: Column 'id' in field list is ambiguous

sql
best-practices
performance
join
explain.codes / Sql