Programming Tips & Tricks
T-SQL Trick: Use Recursive CTE To Get Hierarchical Data
In a previous article we learnt how to use CTE (Common Table Expression) to render dates in a date range. In this example we’ll use somewhat advance technique to show a data in a heirarchical form. Using the regular T-SQL query this is almost impossible to achieve it without coding in a strored procedure […]
Android Phone Tips & Tricks
Wi-Fi Trick: Share Your Wi-Fi Password via Android QR Code
Everybody knows that connecting to a Wi-Fi network is pretty simple if you know its network’s SSID (network name) and password. But many of the users are unaware of yet another convenient way of quickly connecting to a Wi-Fi network by just scanning the QR code. Below we describe both methods, and their advantages […]