Wedding Query........ (SQL Style)
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 ,MBA) 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;