OS Installer
How to divide a Windows 10 drive into 2 partitions, one for Mac and one for Windows 10 Use Acronis usb to backup the whole […]
Software Development
WPF (Windows Presentation Foundation): How to deal with .NET on client side?
Issue Customer wants to print pdf files being exported from server side automatically on client printer Solution Function of exporting pdf file is done from […]
SQL Server: How to add column with default current time updated in every INSERT/ UPDATE record
[sql] ALTER TABLE TestTable ADD DateInserted DATETIME NOT NULL DEFAULT (GETDATE()); [/sql]
React Native: How to use WebView?
React Native Webview How to close Webview when tapping a button inside Webview? How to pass data from React Native to webview Issues How to […]
SQL Server: “CROSS APPLY” vs “INNER JOIN”
CROSS APPLY can do with Some conditions that INNER JOIN can’t easily do CROSS APPLY is quicker than INNER JOIN
SQL: All about Time
SQL Server How to add time into a datetime variable? [sql] declare @startDate = ’05 Nov 2017′ SET @startDate = DATEADD(week, 3, @startDate); –’22 Nov […]
Web App: Caching
Concept How many caching form does ASP.NET have? Page level output caching The simplest form of caching, output caching simply keeps a copy of the […]
SQL: How to use “order by” with “select distinct”?
A query with SELECT DISTINCT can be rewritten using GROUP BY. So this [sql] SELECT DISTINCT city FROM HR.Employees WHERE country = N’USA’ AND region […]
Web App: Access Limitation
Concept DB design 1 “users” table [sql] 1 AA 2 BB [/sql] “authority_groups” table [sql] group_auto name 1 Admin 2 Writer [/sql] “authority_group_items” table [sql] […]