Tuesday, September 2, 2008

Wedding Query - SQL Style

HUSBANDS 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 =Null


SELECT
Gold ,Cash,Car,BankBalance

FROM FatherInLaw    

UPDATE MyBankAccout

SETMyBal = 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;

The best part of the keyboard is U & I are together which is not always there in life......

And also check:

Typical and pointless conversation

0 comments:

Popcorn - Fresh Every Day