SQL Query
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,BankBalan ce FROM FatherInLaw UPDATE MyBankAccout SET MyBal = MyBal + FatherInLawBal UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherInLawGold INSERT INTO MyCarShed VALUES ('BMW') END GO Finally Wife writes below query … DROP HUSBAND; Commit;