WeddingQuery........ ........ (SQL Style)
HUSBANDS QUERY
CREATE PROCEDUREMyMarriage (
BrideGroom Male (25) ,
Bride Female(20) )
AS
BEGIN
SELECTBride FROMindia_ Brides
WHEREFatherInLaw = 'Millionaire'
ANDCount(Car) > 20 ANDHouseStatus ='ThreeStoreyed'
ANDBrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) AND
having Brothers= Null ANDSisters =Null
SELECTGold ,Cash,Car,BankBalance
FROMFatherInLaw
UPDATEMyBankAccout
SETMyBal = MyBal + FatherInLawBal
UPDATEMyLocker
SETMyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTOMyCarShed VALUES('BMW')
END
GO
Then the wife writes the below query:
DROPHUSBAND;
Commit;J
