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 is null  
AND Sisters is 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;