What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 129 Stack Exchange communities.

This question already has an answer here:

I've noticed that the syntax highlighter for code samples does not work with capitalization for SQL. I just posted a question on SO and had to spend a couple extra seconds to modify it to get the highlighting to work... Is this supposed to work?

http://stackoverflow.com/questions/1144172/how-count-the-number-of-times-a-character-appears-in-a-sql-column

Would it be possible to add this to the keywords list?

  • SELECT
  • WHERE
  • FROM
  • INNER
  • OUTER
  • JOIN
  • LEFT
  • RIGHT
  • TOP
  • ORDER BY
  • GROUP BY

I know there are others that would be useful, but didn't want to run through the entire list

share|improve this question

marked as duplicate by ben is uǝq backwards, wax eagle, Manishearth, Rory, Martijn Pieters Jun 14 '13 at 14:26

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

3 Answers 3

up vote 1 down vote accepted

this would have be submitted as a patch to Google Prettify

http://code.google.com/p/google-code-prettify/

share|improve this answer

With the syntax highlighting language hints, you can now splendour your eyeballs on the colours of the keywords per whatever language tag is riding shotgun on the question.

You can also override the default colouring inferred from the tags on the question with a prettify hint:

<!-- language: lang-or-tag-here -->

    code goes here

So an example case in SQL would look like:

<!-- language: lang-sql -->

    SELECT mischief FROM sendak WHERE theWildThings='Imagination'
share|improve this answer

UPPER CASE in SQL is relict of the past...
BTW, are COBOL keywords being displayed properly? :)

share|improve this answer
    
Yet it seems to be the default syntax used in all of the SQL tools... Right click table, select top 1000.... Yields capitalization in keywords... –  RSolberg Jul 17 '09 at 16:19
3  
Hang on... upper case is old hat but case sensitivity is modern? –  gbn Jul 17 '09 at 18:36
1  
@gbn: well, yeah... I mean, case sensitivity wasn't really necessary prior to the introduction of lower-case letters... –  Shog9 Jul 18 '09 at 0:45
1  
@Shog9. Perhaps it's because we dev dbas get used to SHOUTING at client devs all the time ;-) –  gbn Jul 18 '09 at 18:21

Not the answer you're looking for? Browse other questions tagged .