Print Query Analyzer SQL in Colour?

Question

Print Query Analyzer SQL in Colour?

Bill Cockerill

SSC Enthusiast

Points: 195
More actions
April 6, 2005 at 9:43 am

#65633

Dear Forum,
I'd love to print out my SQL code in colour to browse through more easily.
Can this be done in QA or EM or Word?
Thanks, Bill

Viewing 9 posts - 1 through 8 (of 8 total)

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

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 1

As far as I know this cannot be done. The color is a return to screen feature only. I don't know of a 3rd party tool either that will accomplish this.

Good Hunting!

AJ Ahrens

webmaster@kritter.net

PW-201837 SSC-Insane Points: 20805 More actions · Answer 2

Something like Apex SQLEdit would provide this:

http://www.apexsql.com/sql_tools_edit.htm

Also, tools like TextPad and UltraEdit have add-on syntax definition files to syntax highlight various source code types:

http://www.textpad.com/add-ons/synn2t.html

http://www.ultraedit.com/downloads/additional.html

Andy Hilliard Old Hand Points: 344 More actions · Answer 3

You really can't beat EditPad for versatility (http://www.jgsoft.com). It has built-in libraries for every conceivable flavor of SQL (including T-SQL), and also handles any other kind of text editor task you could imagine.

I ran the free version for 2 years before happily ponying up the $30 or $40 for the paid version.

Andy Hilliard
Owl Creek Consulting[/url]

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 4

PW,

I also use Textpad and it DOES highlight on screen but doesn't PRINT color.

Andy,

I will give EditPad a try for printing in Color. Thanks for the tip.....

Good Hunting!

AJ Ahrens

webmaster@kritter.net

dbuchan SSCrazy Points: 2328 More actions · Answer 5

I use UtraEdit32 (not just for this) and it prints in colour - and you can set the colours easily enough. It has language templates for lotsa things.

Good for huge files.

DB

The systems fine with no users loggged in. Can we keep it that way ?br>

Bert De Haes Hall of Fame Points: 3093 More actions · Answer 6

I use gvim, as I am used to work on Unix system. gvim is free, and it prints in color ...

Bert

Lowell SSC Guru Points: 323518 More actions · Answer 7

Another text editor with syntax highlighting, which also prints in color is EditPlus http://www.editplus.com

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 8

If you just want to print in color then use 'Snag-it'.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."