Gradly

CREATE PROCEDURE MyMarriage
@ BrideGroom Char(NotBad),
@ Bride Char(Good);

AS
BEGIN

SELECT Bride FROM USA_ Brides
WHERE
FatherInLaw = ‘Millionaire’ AND
CarCount > 2 AND
HouseStatus =’TwoStoreyed’ AND
BrideEduStatus= ‘PGorAbove’ AND
HavingBrothers= ‘NO’ AND
HavingSisters =’No’ AND
AllowRelocate =’YES’;

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