Articles
How to add better comments into SQL server
Whilst I'm firmly in the 'Tried and Test' camp for most things in life and I may only be new to SQL programming but there are just sometimes when I have to buck the mainstream trend and do it my way.
One of these occasions is comments in SQL, the widely adopted way would be to use the prescribed double dash -- or the widely adopted across multiple more »
Excel - Add comment directly into formulas
Ever known anybody who hardcodes numbers into formulas? Does it drives you mad because they leave no explanation of why? Well this may be the function you should tell them about.
You can use the N() function to add a comment inline with a formula. What it actually is mean't for is to try to convert a string into a number, but if you just put words more »
- Getting ExifTool's move files to directories to work properly as Windows batch file
- How to easily & perfectly align your Stem
- How to remove bicycle tyre marks from painted walls
- What's your Robot name?
- Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi
- How to clean the lid and nozzle of your Camelbak Podium bottle
- How to enable and change the Remote IR GPIO pin in OSMC
- Split and extract the first 1000 (N) rows from a text-csv-data file in Windows
- My new scale for measuring oldness
- A datedif function for excel that calculates correctly
- Raspberry Pi 3 HDMI overscan settings and how to correct them
- Create custom Excel function using an array/range input
- SSL on a RaspberryPi - does it slow your site down?
- Remove Real VNC from RaspberryPi Pixel and install TightVNC
- Running a SSL certificated/authenticated HTTPS website over dynamic DNS