Knowledge Hub

 

SQL: String Concatenation

SQL: String Concatenation

A few days ago I was asked to look over some SQL statements written by someone new to SQL. They were getting some unexpected results when concatenating strings and although they had managed to overcome the issue, they asked that inocent question we all love to ask and hate to be asked; ‘Why?’

Tip: Retrieving SQL Commands from SQL Profiler

Tip: Retrieving SQL Commands from SQL Profiler

So, the other day I am sitting around watching a bit of SQL Profiling on the old laptop, to see what a set of API requests were actually doing to a database, when I realised that there was no easy way to copy the all the executions into my documentation.

Open XML Usage – Part Two

Open XML Usage – Part Two

Add styles and tables. I found it much easier to create re-usable code when creating Word documents. The CreateAndAddCharacterStyle method takes a number of parameters i.e. font, font size, colour, bold setting and italics setting. Once the style is created it can then be applied to a run when creating text.

Open XML Usage – Part One

Open XML Usage – Part One

This will be the first in a short series of articles to show how we use Open XML. Open XML is a Microsoft format which can be used to programmatically create Word documents.

Navigation

Social Media