Monday, August 27, 2012

Huband and Wife's SQL Query

Ever thought if Husband and wife had to write their wishes in a query how would they do it.
I had received this sometime back and it gives an SQL kind of fun to the husband wife jokes.

Wife’s QUERY 

CREATE PROCEDURE MyMarriage (
           BrideGroom Male (25) ,
           Bride Female(20) )
AS
BEGIN 
SELECT
        Bridegrooms FROM India’s Handsome Bridegrooms WHERE
           FatherInLaw = 'Millionaire' AND
           Count(Car) > 5 AND HouseStatus ='ThreeStoreyed' AND  BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA)
AND  Having Brothers= Null
AND Sisters =Null

SELECT Gold ,Cash,Car,BankBalance
FROM FatherInLaw, Husband
UPDATE MyBankAccout
SET MyBal = MyBal + FatherInLawBal

UPDATE MyLocker
SET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTO MyCarShed VALUES('BMW')
END
GO


Then the Husband writes the below query: 

DROP Wife;
Commit; 









No comments:

Post a Comment