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, BankBalance
FROM FatherInLaw
UPDATE MyBankAccout
SET MyBal = 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;
