Explain Codes LogoExplain Codes Logo

Best Articles — Page 158

Passing an array of parameters to a stored procedure

sql
tvp
xml-serialization
dynamic-sql

How to return default value from an SQL query

sql
sql-performance
best-practices
query-optimization

What is the JavaScript string newline character?

javascript
prompt-engineering
functions
regex

How to check whether an object is a date?

javascript
date-validation
defensive-programming
javascript-best-practices

How can I alias a default import in JavaScript?

javascript
import-aliasing
javascript-best-practices
code-readability

How to access a value defined in the application.properties file in Spring Boot

java
spring-boot
property-access
configuration-properties

How to select the last two characters of a string

javascript
slice-method
string-manipulation
javascript-utility

How can I read and process (parse) command line arguments?

python
prompt-engineering
functions
advanced-parsing

Why not use tables for layout in HTML?

html
responsive-design
best-practices
layout

Custom exception type

javascript
exception-handling
error-objects
custom-exceptions

Oracle 'Partition By' and 'Row_Number' keyword

sql
prompt-engineering
join
deduplication

How to select id with max date group by category in PostgreSQL?

sql
prompt-engineering
best-practices
performance

What is the equivalent of 'describe table' in SQL Server?

sql
database-documentation
metadata-visibility
sql-scripts

Open popup and refresh parent page on close popup

javascript
popup-engineering
window-object
event-handling

Javascript OR (||) variable assignment explanation

javascript
short-circuit-evaluation
logical-operators
javascript-best-practices

Command for adding a default constraint

sql
database-design
data-consistency
sql-best-practices

Drop all duplicate rows across multiple columns in Python Pandas

python
pandas
dataframe
drop_duplicates

Make container shrink-to-fit child elements as they wrap

html
responsive-design
flexbox
css

Pandas DataFrame: replace nan values with average of columns

python
pandas
dataframe
fillna

Change <select>'s option and trigger events with JavaScript

javascript
event-handling
browser-compatibility
javascript-events