Hosting – Windows
Install Wamp Config Wamp Change port 80 to 8080 Open the httpd.conf, find “Listen” and change like this [html]Listen 0.0.0.0:8080 Listen [::0]:8080[/html] Find “ServerName” and […]
Software Development
ASP.net & Javascript
What is Ajax life cycle in ASP.NET? http://ajaxtutorials.com/general/client-side-page-life-cycle-with-updatepanel-with-javascript/ Why is Javascript affect gone after postback? Issue When clicking on a button to get selected option […]
SQL: DB/ Table Queries
SQL Server Management Studio How to find a certain string inside a stored procedure/ function [sql]SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, ‘IsProcedure’) = 1 AND […]
SQL statements – SELECT
How to know number of rows being affected by SELECT/INSERT/UPDATE…? SQL Server[sql] UPDATE Employee SET JobTitle = N’Executive’ WHERE NationalIDNumber = 123456789 IF @@ROWCOUNT = […]
Reference – React Native
React Native Podcast reactnativeradio.com State management React State Museum Native + React Native https://artsy.github.io/blog/2018/04/17/making-a-components-pod/ Windows + Mac app by Microsoft https://microsoft.github.io/react-native-windows/ Debug Reactotron react-native-flipper JavaScript […]
node.js
Windows installation Install “msi” file from node js website Create “hello.js” file [js]console.log(‘Hello World’);[/js] Open Windows command prompt [js]node hello.js[/js]
JavaScript & jQuery: HTML DOM
How to debug JavaScript? [js]debugger[/js] Work with string How to split a string into an array? Javascript [js]var text = ‘part1||part2||part3’;var labelArr = text.split(‘||’);[/js] How […]
Windows tricks
Shutdown without updating [js]shutdown /s /f /t 0[/js] How to restore a window? Hold down “Super” key and press “↑” How to adjust screen to […]
Query tuning
General Speed depends much on indexes than other things JOIN is quicker than IN Index Index improves performance of SELECT queries Index should be applied […]