Formatting your code when posting in the forums

When posting questions in the forums with TSQL code, it may be a good idea to format your code so that it looks better in the forums. When the code is formatted and keywords are colored, it will make the code easier to understand.

You can add formatting to the code by placing your code between a <pre> block. Here is an example of a piece of code that uses formatting tags.

<pre class="brush:sql">
-- Check current time
SELECT GETDATE()
</pre>

The above code will be formatted and printed as follows in the forums

-- Check current time
SELECT GETDATE()

Thanks, But sometimes evethough I do it, by default it adds this tag

<divre...>...</divre>

Any reason?

I think it is the editor control that does it. The best is to compose your text and then go to 'html' view(there is a button on the toolbar of the editor) and paste the tsql code within the <pre> block.

Yes. Usually I do this only

I tried several times to set my text correctly using HTML editor, but it didn't work :( I'm using IE 8 and I tried to do everything in the HTML editor - it still didn't work after I pressed 'Update' button.

You need to insert the "pre" blocks by going to the HTML source page rather than the wysiwyg editor. It is a little awkward. If you use Windows Live writer to compose your blog posts, then it will be much easier. you can use the plugin given here: http://www.codeplex.com/wlwSyntaxHighlighter

I was doing it directly in the editor you have on this site, then pressing Html button, then inserting pre tags there, then pressing update. It didn't work and when I went back to HTML view I saw divpre tag instead of pre tag I put.

Test of the code here.

select @@VERSION 

Correct, this one works. You can find an option in the profile to select the editor you wish to use. (wysiwyg or html).