SQL Variable, Temporary and Global Tables

March 1, 2023

SQL procedures can create multiple types of table entities – it’s up to you do decide which one is best. The Simplest: Table Variable If you just want to capture some information to be used in the body of a stored procedure and the table creation and usage is in a single batch (no “GO” statement between creation… Read More »

SQL Scalar Variables

February 28, 2023

SQL scalar variables (otherwise known as local scalar variables) must be defined with type and set to a value before the variable can be used. This can be done in two steps or as a single step. Additional Links

Using the Select Automation with Python Code Snippets

February 28, 2023

Select allows you to supplement the “canned” conditions and activities for Automation with Python code. The object passed to the code (context) depends on how the automation task is coded. The context can come from at least five sources. Python Hooks in Automation Automation can host Python snippets in both the condition and activity areas. The way automation… Read More »

Loading Additional .NET Assemblies

June 1, 2020

There are times you want to add an additional .NET library to your code. It might be an actual Microsoft assembly or from another vendor. First you import CLR then add the desired assembly. (Note that the DLL must be either in the GAC or the executable folder.) Finally import the type/class namespace(s). If you want to minimize… Read More »

Raspberry Pi 2 Model B v1.2 Specifications

February 28, 2023

Adafruit article on the Raspberry Pi 2 – Model B Cortex-A53 processor v1.2 PCBs and Pi 3 Raspberry Pi GPIO Header pinouts Raspberry Pi Hardware page from the mothership page BCM2835 ARM Peripherals Kernel GPIO# ALT0 function Pin# Pin# ALT0 function GPIO# +3.3 V 1 2 +5 V 2 SDA1 (I²C, PCB 1.8k PUP to 3.3V) 3 4… Read More »