Explain Codes LogoExplain Codes Logo

Topics

Java iconJavaPython iconPythonHTML iconHTMLSQL iconSQLJavaScript iconJavaScriptCareer iconCareer

Best Articles — Page 37

Must declare the scalar variable: *How to Rid Your Code of this Pesky Error*

sql
sql-injection
dynamic-sql
variable-declaration

Increment Row Number on Group

sql
dense-rank
row-number
materialized-views

Working with UTF-8 encoding in Python source

python
unicode
utf-8
encoding

Aws Error Message: A conflicting conditional operation is currently in progress against this resource

aws
s3-buckets
synchronization-issues
error-handling

The tail of the log for the database "DBName" has not been backed up

sql
backup-strategy
database-restore
sql-server

Create a Cumulative Sum Column in MySQL

sql
cumulative-sum
mysql
window-functions

Converting Integer to String with comma for thousands

java
number-formatting
locale-preferences
decimalformat

What are practical differences between `REPLACE` and `INSERT ... ON DUPLICATE KEY UPDATE` in MySQL?

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

Remove blank attributes from an Object in Javascript

javascript
prompt-engineering
functions
immutability

What is the "owning side" in an ORM mapping?

java
orm-mapping
database-design
entity-relationship

Why do I get "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." when I try to use sp_executesql?

sql
sql-server
dynamic-sql
nvarchar

Storing JSON in database vs. having a new column for each key

database
data-modeling
database-design
performance-optimization

In a join, how to prefix all column names with the table they came from

sql
dynamic-sql
column-aliases
sql-injections

Base64 Java encode and decode a string

java
base64-encoding
java-8
best-practices

Error: " 'dict' object has no attribute 'iteritems' "

python
python-3
dict
compatibility

How can I mix LaTeX in with Markdown?

python
pandoc
latex
markdown

Language SQL vs LANGUAGE plpgsql in PostgreSQL functions

sql
database-optimization
function-design
sql-performance

How can I truncate table cells, but fit as much as content possible?

html
responsive-design
css
table-layout

What is a Maven artifact?

java
maven-coordinates
dependency-resolution
build-process

Gradle - Error Could not find method implementation() for arguments [com.android.support:appcompat-v7:26.0.0]

java
gradle
build-performance
dependency-management
explain.codes