Displaying SQL Server Syntax in WordPress

Question

Post reply

Displaying SQL Server Syntax in WordPress

Jared

SSC Guru

Points: 61793
More actions
January 10, 2012 at 9:12 am

#266232

Anybody have a good plugin or way to display SQL Server syntax in WordPress? Images are great, but I think allowing people to copy and paste is much better. I have found some plugins, but the colors aren't as they should be. Any thoughts?
Jared
CE - Microsoft

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

I'm using wordpress.com and there you just need to surround your code with

[sourcecode language=sql]

SELECT SomeColumn FROM SomeTable

[/sourcecode]

and everything displays just fine, with copy,print,view source and help buttons.

You can see it at spaghettidba.com.

Is this what you're after?

-- Gianluca Sartori

Jared SSC Guru Points: 61793 More actions · Answer 2

Gianluca Sartori (1/10/2012)
I'm using wordpress.com and there you just need to surround your code with
[sourcecode language=sql]
SELECT SomeColumn FROM SomeTable
[/sourcecode]
and everything displays just fine, with copy,print,view source and help buttons.
You can see it at spaghettidba.com.
Is this what you're after?

Yeah, that is nice, but I was hoping to get a color scheme that mimics SSMS. Maybe I will have my brother build a plug-in for that 🙂

Jared
CE - Microsoft

_Beetlejuice Ten Centuries Points: 1064 More actions · Answer 3

Use Windows Live writer.

You can publish directly to WordPress from there, and it keeps all of the formatting\colours

http://explore.live.com/windows-live-essentials-other-programs?T1=t5

Jared SSC Guru Points: 61793 More actions · Answer 4

_Beetlejuice (1/10/2012)
Use Windows Live writer.
You can publish directly to WordPress from there, and it keeps all of the formatting\colours
http://explore.live.com/windows-live-essentials-other-programs?T1=t5

Very interesting! I will check this out later tonight to see how it works. Thanks!

Jared
CE - Microsoft

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

SyntaxHighlighter plugin.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jared SSC Guru Points: 61793 More actions · Answer 6

GilaMonster (1/10/2012)
SyntaxHighlighter plugin.

🙂 That's what I finally got. I didn't realize that the shortcodes are only built in through wordpress.com. Thanks Gail!

Jared
CE - Microsoft