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 » SQLServerCentral.com » Contests! » T-SQL Haiku
Add to briefcase
41 posts, Page 2 of 5
««12345»»»

T-SQL Haiku Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
RBarryYoung
Posted Wednesday, June 25, 2008 6:57 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374
Ken Simmons (6/24/2008)
DROP DATABASE FILE
IF NO BACKUP TO RESTORE
BEGIN TO DENY


ROFL!

Beautiful, Ken.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
Post #523250
sgmunson
Posted Thursday, June 26, 2008 8:07 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:20 AM
Points: 1,446, Visits: 1,883
How about the following?

BEGIN TO COMMIT
WHEN RECEIVE DUMP
THEN END CONVERSATION

Kind of silly, but I got a laugh out of it...
especially when I considered how RELATIONAL it is :D:P

Steve
(aka smunson)
:D:D:D

Steve
(aka sgmunson)

Weight Loss Tips
Post #524202
RBarryYoung
Posted Thursday, June 26, 2008 9:14 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374
smunson (6/26/2008)
How about the following?

BEGIN TO COMMIT
WHEN RECEIVE DUMP
THEN END CONVERSATION

Kind of silly, but I got a laugh out of it...
especially when I considered how RELATIONAL it is :D:P

Steve
(aka smunson)
:D:D:D

It does not conform to the rules. The "Haiku" are supposed to consist of 3 lines, with 5 syllables in the first line, 7 syllables in the second and 5 syllables in the last line. Yours is (4,4,6), not (5,7,5).

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
Post #524292
sgmunson
Posted Thursday, June 26, 2008 9:59 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:20 AM
Points: 1,446, Visits: 1,883
OOPS !!! Wasn't familiar with the specifics on that... here's a fix:

BEGIN TO COMMIT
WHEN RECEIVE CONTAINS DUMP THEN
END CONVERSATION

Turns out I did have 5 on line 1, but then it was 4 and 6 instead of 7 and 5.

Steve
(aka smunson)
:):):)

rbarryyoung (6/26/2008)
smunson (6/26/2008)
How about the following?

BEGIN TO COMMIT
WHEN RECEIVE DUMP
THEN END CONVERSATION

Kind of silly, but I got a laugh out of it...
especially when I considered how RELATIONAL it is :D:P

Steve
(aka smunson)
:D:D:D

It does not conform to the rules. The "Haiku" are supposed to consist of 3 lines, with 5 syllables in the first line, 7 syllables in the second and 5 syllables in the last line. Yours is (4,4,6), not (5,7,5).

Steve
(aka sgmunson)

Weight Loss Tips
Post #524331
Ivanna Noh
Posted Thursday, June 26, 2008 10:41 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: Wednesday, May 15, 2013 6:26 PM
Points: 777, Visits: 2,306
SQL pick up line...

GETDATE FOR USER
IF LANGUAGE IS NOT FOREIGN
TRY CONVERSATION
Post #524753
Ivanna Noh
Posted Thursday, June 26, 2008 10:59 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: Wednesday, May 15, 2013 6:26 PM
Points: 777, Visits: 2,306
...or if that doesn't work...

NO CONVERSATION
WAITFOR END OF DAY AND THEN 
TRY UNION INSTEAD



Post #524761
sgmunson
Posted Friday, June 27, 2008 6:39 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:20 AM
Points: 1,446, Visits: 1,883
Well, Ivanna, that makes a total of three RELATIONAL verses in T-SQL Haiku... How database is that ???? :D:D:D

And as long as we're using a RELATIONAL language, how about:

IF DATE IS DATEFIRST
THEN TRY NOT HAVING ANY
INSERT INTO DATE

:D:D:D

Not sure if I'll get away with this one though... It's a cautionary tale, if that helps...

Steve
(aka smunson)
:):):)

Steve
(aka sgmunson)

Weight Loss Tips
Post #524925
rudy - Doctor "X"
Posted Friday, June 27, 2008 10:32 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: Friday, May 17, 2013 2:11 PM
Points: 3,108, Visits: 2,114
master full user
values unique union
with distinct order



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #525179
rudy - Doctor "X"
Posted Friday, June 27, 2008 11:26 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: Friday, May 17, 2013 2:11 PM
Points: 3,108, Visits: 2,114
kill current user
and begin to shutdown key
user database



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #525216
Matt Miller (#4)
Posted Friday, June 27, 2008 11:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:57 PM
Points: 6,998, Visits: 13,949
rudy komacsar (6/27/2008)
master full user
values unique union
with distinct order
or schemabinding! :P

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #525220
« Prev Topic | Next Topic »

Add to briefcase
41 posts, Page 2 of 5
««12345»»»

Permissions Expand / Collapse

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