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

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

CREATE PROCEDURE MyMarriageBridegroom Male (25) ,Bride Female(20) ASBEGINSELECT Bride FROM India_ BridesWHERE Father-In-Law = 'Millionaire' AND Count(Car) > 20 AND House Status ='ThreeStoreyed'AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MBA) AND Having Brothers= Null AND Sisters =Null


SELECT Gold ,Cash,Car,BankBalanceFROM Father-In-Law

UPDATE MyBankAccout SETMyBal = MyBal + FatherInLawBal
UPDATE MyLockerSET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTOMyCarShed VALUES('BMW')
END
GO



Then the wife writes the below query:


.
..
.
.
.

..
.

.
.
.
.

..

..
.
.
..
.
.
.
.
.
.
.
.
.
.
.
.

DROP HUSBAND;

Commit;