The wp-code-plugin.zip is plugin for WordPress that lets you put formatted code in your blog. Install the plugin by unzipping the zipped file to rootwp-contentplugins folder. You are ready to go. Go to Plugins Menu and click active in front of “WP Code Plugin”. This plugin is dependent on two sites
1. Prettify SQL
The above links lets you format your SQL code (SQL only).
2. C# Code Formatter
The above link lets you format C#/VB/t-sql/html code in html format.
Lets say you want to insert sql code snippet into your blog. The code snippet is “SELECT firstname,lastname, course from student_tbl”. Copy this query in sql formatter, click “Format SQL” Button. Go to the bottom section where it says “Following html code can be used in website”. Click on “Copy HTML to clipboard”. Now put the copied code in pre block in your block, the result will be the following