SQL Server: How to use SQL Server Profile
How to trace which stored procedures are called Open “Trace Properties” window Select “Event Selection” tab Check “Show all events”, “Show all columns” tab Check […]
Software Development
Windows Service – Error: “Service on Local Computer started and then stopped”
Error message meaning [html] This means code is throwing an unhandled exception. [/html] Debug Event Viewer -> Windows Logs -> Application [html]Login failed for user […]
React Native & iOS & Android
How to convert iOS app to Android app?
React Native: How to request an API?
How to request localhost API from Android emulator? Change the API endpoints in your Android code to http://10.0.2.2 How to GET json data? How to GET […]
ReactJS vs JSX vs Javascript
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] […]
HTML & CSS: All about
How to align text full left and right? How to align item to right? How to create a box with border? How to create a […]
SQL Statements – JOIN
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 […]
SQL statements – INSERT
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 […]