June | 2015 | boltblog

Using MERGE to insert/update in SQL Server

Unknownbolt | 2015-06-19

After finding various useless references on how to use the MERGE statement in SQL Server 2008, I found this one that I could use, so I copied it here for personal reference: MERGE tablename AS target USING (VALUES (‘new value’, ‘different value’)) AS source (field1, field2) ON target.idfield = 7 WHEN MATCHED THEN UPDATE SET […]

How to use a gateway outside of the local subnet on Linux

Unknownbolt | 2015-06-15

An interesting situation occurs when you have a very limited range of public IP addresses and want to pass all traffic through a common gateway without “wasting” a public IP on that – you may find yourself wanting to use a gateway with a private IP even through your network uses public ones. So, in […]