Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Chad Crawford » Reformat via query?
Add to briefcase
28 posts, Page 2 of 3
««123»»

Reformat via query? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Steven Cameron
Posted Friday, July 11, 2008 7:16 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 06, 2009 1:29 PM
Points: 2,057, Visits: 215
Getting the red error message is easy. Just type SELECT and execute. A red error message will appear which can then be changed to whatever you want and it will still be in red. The go to the beginning of the text and add a blank line. Anything typed on the blank line will be in black.
Post #532408
webrunner
Posted Friday, July 11, 2008 8:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:05 PM
Points: 2,117, Visits: 2,209
This is a great question to keep people from cheating by running it. :)

Cheers,
webrunner

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #532456
rudy - Doctor "X"
Posted Friday, July 11, 2008 8:33 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:11 PM
Points: 3,108, Visits: 2,114
A really great chuckle to start off a Friday !



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #532504
Jamie Longstreet-481950
Posted Friday, July 11, 2008 8:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:57 PM
Points: 2,440, Visits: 712
Possibly trite but finding the sense of humor on these questions can be as adverse as some of the toughest questions. I comment when right and for obvious reasons, I do not comment frequently on humor.

Jamie
Post #532514
Nick W*
Posted Friday, July 11, 2008 8:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 22, 2012 8:55 AM
Points: 124, Visits: 180
SELECT Location
FROM Emotions
WHERE Emotion = 'Sense Of Humour'
AND Owner = 'Your'







*Ducks the incoming abuse*
Post #532526
gaurav.bhagat
Posted Friday, July 11, 2008 8:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2012 8:57 AM
Points: 849, Visits: 128
freaked out a couple of coworkers :D... told them right before they officially were abt to document/put a call to the dba..
Post #532530
Jamie Longstreet-481950
Posted Friday, July 11, 2008 8:54 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:57 PM
Points: 2,440, Visits: 712
That one shines Nick. Probably one of the best queries ever written.

Jamie
Post #532532
Chad Crawford
Posted Friday, July 11, 2008 8:59 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 2,548, Visits: 17,348
It is possible to replicate the results, Open up a query window to a database and type in "SELECT * FROM sys.master_files", then open "activity monitor" and kill the SPID which corresponds to the Query window.

"BLAHBLAHBLAH" works too... anything that will give you red text in the Messages window to start with

P.S. Putting the question in the category 'Humour' kinda gives it away though

Well... and that was actually why I put it in humor. I guess I'm a little gun shy after some of the QODs have been hammered by upset people missing it due to a misunderstanding, and this is somewhat obscure and not that technical in nature.
Post #532536
Manie Verster
Posted Friday, July 11, 2008 10:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:01 AM
Points: 1,151, Visits: 878
Very good one! I remember back when Windows 3.1 came out and I was still learning Windows someone gave a program to me and said if I install it on my computer I'll have some cool screensavers and games to play. Well, gullable as I was I installed it and all of a sudden an error message popped up saying the program cause a general failure only had an OK button. So, I clicked OK and another error came up and only OK to click and it happened one after the other until my whole screen became distorted and eventually black. I thought I had lost my computer until another message came up saying: "HAHAHA!!! I bet you had a good fright!!! Relax it's a joke!". Needless to say I was to relieved to be cross! I still want to pull a prank like that on someone!

Manie Verster
Developer
Johannesburg
South Africa

Life is about choices.... I choose to be happy today
Post #532674
Peter Schott
Posted Friday, July 11, 2008 2:31 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 5:37 PM
Points: 737, Visits: 920
I also found it amusing, but how does one choose a "correct" answer when the type is humor? To me, while this may be the most logical explanation, the others were also funny. Does one get points regardless of the answer chosen? Should someone get points regardless of the answer chosen?


Post #532815
« Prev Topic | Next Topic »

Add to briefcase
28 posts, Page 2 of 3
««123»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.