T-SQL Haiku

  • Many thanks to Derek Karpinski for providing the basis of this idea!

    Let's have a haiku contest!

    You can only use the Reserved Keywords for T-SQL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/ed8b3e27-6796-40f0-aef3-0cac5e0e2418.htm), and the non-fancy old 5-7-5 kind of Haiku.

    Yes, it's a silly idea. But you may also see a keyword you didn't know existed and learn something new 😀

    I offer this hairball of creativity, posted earlier on a derail:

    DENY SOME USER

    IDENTITY IS SHUTDOWN

    PRIMARY ESCAPE

  • I call this one "Bear Sterns"

    DEFAULT TRANSACTION

    CROSS PUBLIC DECLARE DUMP GROUP

    USE TRIGGER DUMMY

  • What a fun idea!

    LOAD CURRENT_USER

    AUTHORIZATION UPDATE ALL

    BROWSE NOT WITH CONSTRAINT

  • I call this "Presidential Campaign, 2008":

    [font="Courier New"]WAITFOR PRIMARY

    SELECT RIGHT IDENTITY

    PRECISION IS ALL

    [/font]

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Very nice! I like that one.

  • Thanks, Steve!

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • CHECK DUMMY IN GROUP

    AUTHORIZATION DENY

    TRY SAVE DUMMY NOT

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life
  • public statistics

    trigger off foreign values

    convert user view

  • escape outer view

    cascade is like cross current

    primary break between

  • DROP DATABASE FILE

    IF NO BACKUP TO RESTORE

    BEGIN TO DENY

  • Ken Simmons (6/24/2008)


    DROP DATABASE FILE

    IF NO BACKUP TO RESTORE

    BEGIN TO DENY

    ROFL! :laugh:

    Beautiful, Ken.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • 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 :w00t::D:P:hehe:

    Steve

    (aka smunson)

    :D:D:D

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • 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 :w00t::D:P:hehe:

    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).

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • 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 :w00t::D:P:hehe:

    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) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • SQL pick up line...:w00t:

    GETDATE FOR USER

    IF LANGUAGE IS NOT FOREIGN

    TRY CONVERSATION

Viewing 15 posts - 1 through 15 (of 40 total)

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