Home
Resume
Posts
Personal
Code

Subscribe

code

Code for humans, data for computers

Robin Michael

Feb 17, 2017 • 1 min read

Guiding principle.

The opposite approach started the XML wars from the turn of the century.

Sign up for more like this.

Enter your email

Alter stored procedure across databases

Needed to alter a particular stored procedure over a few thousand databases. Here is an example script that uses a cursor and dynamic sql to do this. Key point here is to have the USE statement switch the database prior to issuing the CREATE OR ALTER command so that each

Robin Michael Jul 22, 2021 • 1 min read

Time for a summer beach trip

Robin Michael Jul 7, 2021 • 1 min read

Handling implicit varchar conversions

Got some quirky unexpected behavior when loading data from text files and SQL statements when working with extended ASCII characters and Unicode. These files in particular are UTF8 encoded as is standard when doing text editing and contain strings with contents like so æ2Ç9£╖♫↕◄‼↨∟. File editing example Visual Studio CodeExampleText

Robin Michael Jul 2, 2021 • 2 min read

Empty Space © 2021

Powered by Ghost