dp.SyntaxHighlighter 1.5.2 Tests and Samples

http://code.google.com/p/syntaxhighlighter/

SQL

Languages:

  1. C#
  2. CSS
  3. C++
  4. Delphi
  5. Java
  6. JavaScript
  7. PHP
  8. Python
  9. Ruby
  10. SQL
  11. Visual Basic
  12. XML / HTML
  13. Scala
  14. Groovy
  15. Bash

Features:

  1. Smart tabs
  2. First line
  3. Expand code
  4. Show columns
  5. Blogger integration
  6. No gutter
  7. No controls

Issues:

  1. #7, XSL transformation
  2. #15, Incorrect single quote
  3. #10, VB crash
  4. #19, No matches
Block before.
SELECT TOP 10
	FirstName,
	LastName,
	Email,
	--SUBSTRING(Phone, 2, 3) AS CityCode,
	SUBSTRING(Phone, 7, 8) AS PhoneNumber,
	upper(LanguagePref) AS Language,
	Address1,
	UpdatedOn AS CreatedOn
FROM
	profiles
WHERE
	-- Exclude all test emails
	Email NOT LIKE '%test%'
	AND Email NOT LIKE '%asdf%'
ORDER BY
	UpdatedOn DESC
Block after.