Ok, quickly before I go to bed.
I've seen some code highlighters on the web before. The one I use in this blog is adapted from what I saw on the Prototype Carousel page, which is based on Star-Light.
To get them to work with Blogger, I had to link the scripts like on Carousel, but I would MUCH PREFER to use Star-Light as is.
I will be adapting the T-SQL Star-Light styles into the other way for an upcoming SQL Server 2005 Ad-Hoc Report Model/Dynamic Query PIVOT goodness post.
UPDATE: I switched back to Code_Highlighter from the Carousel page because it works in Firefox without having to reload the iframe, and it just works in IE7)