Monday, December 24, 2007

Wedding Query..... (SQL Style)

CREATE PROCEDURE MyMarriage

BrideGroom Male (25),
Bride Female(20) AS

BEGIN

SELECT Bride FROM india_ Brides WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 10 AND HouseStatus = 'ThreeStoreyed'AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MBA) AND HavingBrothers = Null AND Sisters = Null

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 Bride writes the below query:

DROP HUSBAND;

Commit;

No comments: