Wedding Query........ (SQL Style)


Wedding Query........ (SQL Style)


CREATE PROCEDURE


MyMarriage
BrideGroom Male(25),
Bride Female20) AS
BEGIN

SELECT Bride FROM
India_Brides
WHERE FatherInLaw = 'Millionare' AND
Count(Car) > 20 AND
HouseStatus = 'ThreeStoreyed'
AND BrideEduStatus IN (B.TECH, BE, Degree, MCA, MBA) AND Having Brothers = Null

SELECT Gold, Cash, Car, BankBalance
FROM FatherInLaw
UPDATE MyBankAccount
SET MYBalance = MyBalance + FatherInLawBalance

UPDATE MyLockerContents = MYLockerContents + FatherInLawGold

INSERT INTO MyGarage VALUES('MERCEDES')
END
GO

Then the wife wrote the following query:-

DROP HUSBAND;


Commit;