Software Development

No Image

ReactJS vs JSX vs Javascript

September 6, 2017 hung-nb 0

https://facebook.github.io/react/docs/introducing-jsx.html Object JSX represents object The following declarations are the same because Babel compiles JSX down to React.createElement() calls[js]const element = ( Hello, world! );[/js] [js] […]

No Image

SQL Statements – JOIN

August 27, 2017 hung-nb 0

INNER JOIN Return common records from 2 tables LEFT JOIN Return all records from LEFT table Return matching records from RIGHT table CROSS JOIN OUTER […]

No Image

SQL statements – INSERT

August 22, 2017 hung-nb 0

How to INSERT data? How to insert by EXECUTE sql string? Example [sql] DECLARE @strSQL varchar(max) SET @strSQL = ‘SELECT * FROM <one_table>’ INSERT INTO […]

No Image

Git

August 18, 2017 hung-nb 0

Useful commands What’s Git LFS? For projects containing large files, particularly large files that are modified regularly, this initial clone can take a huge amount […]

No Image

Excel

August 18, 2017 hung-nb 0

[Idea]How to compare values of 2 columns? [Solutions]Use formula to return match/ un-match results in a separate column [Techniques]Comparison [js]=IF(A2=B2), "Match", "Unmatch")[/js] [Techniques]Case sensitive comparison […]

No Image

Ebook – JavaScript

August 9, 2017 hung-nb 0

The Modern Javascript Types Use “null” to write an “empty” or an “unknown” value into the variable “undefined” is only used for checks, to see […]