Mginger

Wednesday, October 31, 2007

WeddingQuery……. …… (SQL Style)

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,BankBalanceFROM FatherInLaw
UPDATE
MyBankAccout SETMyBal = MyBal + FatherInLawBal
UPDATE
MyLockerSET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTO
MyCarShed VALUES(’BMW’)
END
GO

Then the wife writes the below query:

DROP HUSBAND;
Commit;

1 comment:

Anonymous said...

Nice blog,
wanna link exchange?

http://mp3nation.blogspot.com