Funny SQL

sanoka

Well-known member
  • Dec 6, 2007
    5,147
    1,233
    113
    Wedding Query........ ........ (SQL Style)

    HUSBAND’S QUERY


    CREATE PROCEDURE MyMarriage (
    BrideGroom Male (25) ,
    Bride Female(20) )

    AS
    BEGIN


    SELECT Bride FROM india_ Brides
    WHERE FatherInLaw = 'Millionaire'

    AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed'
    AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) AND Having Brothers= Null

    AND Sisters =Full :P



    SELECT Gold ,Cash,Car,BankBalance

    FROM FatherInLaw

    UPDATE MyBankAccout

    SET MyBal = MyBal + FatherInLawBal


    UPDATE MyLocker

    SET MyLockerContents = MyLockerContents + FatherInLawGold

    INSERT INTO MyCarShed VALUES ('BMW')
    END
    GO





    Then the wife writes the below query:

    DROP HUSBAND;
    Commit;
    :baffled: