Wednesday, 31 March 2021

Insert list of strings into temp table

create table #tempListOfThings ( thing varchar(50) )

INSERT INTO #tempListOfThings (thing) VALUES ('val1'), ('val2'), ...

Tuesday, 21 January 2020

Deleting a windows service

There seems to be more than one way to do this, but is a nice easy one:

sc delete "My Service"

Friday, 22 November 2019

Comparing file versions

Here's a good way of comparing file versions. I had to use this in a recent service installer.