Friday, September 23, 2011

SQL Query Funny!!!!!‏

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 



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;

No comments: