SQL String Functions
Useful functions which will allow to modify the strings within SQL query.
Orange pork and Chinese rice
Zesty, speedy and super-simple to make.
Run Excel VBA
Script to open Excel spreadsheet and run VBA code using Powershell.
Query DATETIME field using only date
SQL query where it can get data from a field where date is together with time based just on the…
Save file to SQL database
Code to save a file as binary into SQL database. Can be used in Excel and Access.
Find out file size
Simple script to find the size of the file.