|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Colour My WorldIn SQL Server 2000 Query Analyzer, is there a way to print T-SQL code with
the QA color coding? When I print, even to a color laser printer, everything including the keywords and comments come out in black and white. Thanks! >> In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code Not sure if direct printing is possible or not. This might be silly but if >> with the QA color coding? the code is small enough to fit the screen, you could use a screen print to a word document and then print it. -- Anith Screen capture could work, but the code is many, many pages long.
Is this possible in SQL Server? If not , are there any 3rd party programs that might work? Thanks again... Show quote "Anith Sen" wrote: > >> In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code > >> with the QA color coding? > > Not sure if direct printing is possible or not. This might be silly but if > the code is small enough to fit the screen, you could use a screen print to > a word document and then print it. > > -- > Anith > > > >> When I print, even to a color laser printer, everything including the keywords and comments come out in black and white. <<Just for fun, you might want to research the effect of "colored code" on maintaining it. There is a standard test for brain damage where you show the subject a seires of flashcards with the names of colors in colored ink (I.e. "RED" pritned in green ink) and ask them to call out the either word or the color. This has nothing to do with being color-blind. Since it involves switching brain hemispheres and thus the physical structure of the brain as a organ, the rate is fairly constant over a person's lifetime. Unless they get some physical damage to the brain. Strongly analytical ("left brain, right hand") people have an awful time with "neon vomit programming tools" because they have to filter out the colors to abstract the code from the text. So, I have to ask, why would you ever want to do this? Get a copy of SQL PROGRAMMING STYLE for some more info on how humans read code. I did a bit of the work on this back in the 1980's for AIRMICS while I was a Georgia Tech. Why would I want color-coded printouts? for the same reason they're
color-coded on the screen. Easier to separate what's code, what's keywords, and what's comments. As far as the brain damage research, although it sounds rather intriguing, considering how many more years of my life I'm going to spend looking at M&M colored typing, I may be better off not knowing... Show quote "--CELKO--" wrote: > >> When I print, even to a color laser printer, everything > including the keywords and comments come out in black and white. << > > Just for fun, you might want to research the effect of "colored code" > on maintaining it. There is a standard test for brain damage where you > show the subject a seires of flashcards with the names of colors in > colored ink (I.e. "RED" pritned in green ink) and ask them to call out > the either word or the color. This has nothing to do with being > color-blind. > > Since it involves switching brain hemispheres and thus the physical > structure of the brain as a organ, the rate is fairly constant over a > person's lifetime. Unless they get some physical damage to the brain. > > > Strongly analytical ("left brain, right hand") people have an awful > time with "neon vomit programming tools" because they have to filter > out the colors to abstract the code from the text. > > So, I have to ask, why would you ever want to do this? Get a copy of > SQL PROGRAMMING STYLE for some more info on how humans read code. I > did a bit of the work on this back in the 1980's for AIRMICS while I > was a Georgia Tech. > > Well, cut-n-paste it into MS Word - that should do the trick ;)
Nope, tried it. Still black-and-white in MS Word.
Show quote "Alexander Kuznetsov" wrote: > Well, cut-n-paste it into MS Word - that should do the trick ;) > > I don't know if it is an option or not, but the 2005 replacement of QA (Management Studio) does keep
formatting (including colour) when you copy text. Personally, I hate that, but it might be an upside in these situations. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Joel" <J***@discussions.microsoft.com> wrote in message news:F6077A67-C933-47CA-A4C5-654D2E7881A8@microsoft.com... > Nope, tried it. Still black-and-white in MS Word. > > "Alexander Kuznetsov" wrote: > >> Well, cut-n-paste it into MS Word - that should do the trick ;) >> >> > Personally, I hate that, me too. Sometimes I need to paste into notepad - that removes colorsand fonts > me too. Sometimes I need to paste into notepad - that removes colors I do it all the time, but to QA. I use QA as an intermediate place for applications that keep source > and fonts formatting. I could have used Notepad instead, but I happen to have a shortcut to QA. :-) -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Alexander Kuznetsov" <AK_TIREDOFSPAM@hotmail.COM> wrote in message news:1139708836.253263.259470@f14g2000cwb.googlegroups.com... >> Personally, I hate that, > > me too. Sometimes I need to paste into notepad - that removes colors > and fonts > >I don't know if it is an option or not, but the 2005 replacement of QA It's particularly annoying when copying code into a newsgroup post. Not >(Management Studio) does keep formatting (including colour) when you copy >text. Personally, I hate that, only because it changes the format from plain text to HTML, but also because of all the extra line breaks that then need to be corrected. So, sadly, I've developed a habit of (a) keeping QA open for 2000 stuff, and (b) using notepad as a middleman for 2005 stuff. There should be a toggle to turn that feature on or off, IMHO. On Fri, 10 Feb 2006 08:51:29 -0800, "Joel"
<J***@discussions.microsoft.com> wrote: >In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code with I use Macromedia's Homesite. You can set the colors for each entity.>the QA color coding? When I print, even to a color laser printer, everything >including the keywords and comments come out in black and white. > >Thanks! What you see on the screen is what prints. I also use Ultra Edit and Slick Edit. Both of these allow you to print a selection where Homesite will only print the entire file. I like the printout from Homesite best. -- BettyB -- www.flamingo-code.com "I have noticed even people who claim everything is predestined, and that we can do nothing to change it, look before they cross the road." - Stephen Hawking  |
|||||||||||||||||||||||
Other interesting topics