Explain Codes LogoExplain Codes Logo

Best Articles — Page 38

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

Sql Update from One Table to Another Based on ID Match

sql
update
join
merge

How to set min-font-size in CSS

html
responsive-design
css-functions
accessibility

Jquery selectors on custom data attributes using HTML5

javascript
prompt-engineering
selectors
custom-data-attributes

Filter values only if not null using lambda in Java8

java
lambda
stream-processing
null-safety

Remove uniqueness of index in PostgreSQL

sql
database-management
postgresql
index-management

Maintain image aspect ratio when changing height

html
responsive-design
css
web-performance

Access variables and functions defined in page context from an extension

javascript
script-injection
extension-development
page-context

How do I find records that are not joined?

sql
join
best-practices
performance

Boolean 'NOT' in T-SQL not working on 'bit' datatype?

sql
bitwise-negation
sql-queries
performance-tips

To Call onChange Event After Pressing Enter Key

javascript
event-handling
react-hooks
state-management