I was getting tired of pre-formatting code in LiveWriter. I love that software, but a couple of the technical things are a PIA. So after messing with this for weeks, hand fixing code blocks, I did the smart thing and Google’d for a plug in.

I found this one, Insert Code for Windows Live Writer, which seems to work well. It installs another “insert” level item called Code

I can click that, paste in code, and it color codes it. Here’s a sample snippet of T-SQL.

--===== Simple sum/total for each year
SELECT Year,
SUM(Amount) AS Total
FROM #SomeTable1
GROUP BY Year
ORDER BY Year

I picked that up from Jeff Moden’s article cut and pasted it in here. Looks great to me. We’ll see how it holds up. The only downside so far is that it defaults to C# and I have to switch it to TSQL.